Drop down in Google Drive Sheet

I have a need to develop a relatively simple data entry form to be used on a mobile phone. I can create a suitable form easily in Excel and save it on Google Drive but the dropdown (data validation list) doesn't work. Is there a way of doing it without having to buy a full version of Excel for every user?  

I have looked at various commercial providers of forms for mobile phones but none of them are realistically suitable.

Basically what I need is some basic data at the top, (i.e. Name and lunch break mins) and then a small table with about 10 rows and the following columns:
Date
Time
Doing     (This needs to be a drop down with about 10 or so choices)
JobLoc    (Free text)
Transport (This too needs to be a drop down with about 10 or so choices)

When I get the data I need to enter the data in a job costing program that I plan to develop using MS Access
LVL 1
Rob4077Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rgonzo1971Commented:
HI,

pls try from google reference

Create an in-cell dropdown list


You can create dropdown lists in individual cells using the data validation tool in Google Sheets. There are two options for in-cell dropdown lists: validation against a range and custom lists.

Follow these steps to create an in-cell dropdown list based on a range of cells or a list:
1.Select the cell or cells in which you'd like to create a dropdown list.
2.Under the Data menu, select Validation....
3.In the dropdown menu next to "Criteria," select either List from a range or List of items. •If you selected "List from a range," select a range of cells containing the values that will populate the list. If you change the contents of the range you've selected, the changes will be reflected in the list contained in the validated cell.
•If you selected "From a list," enter a set of custom values, separated by commas. For example, you could enter "peaches,plums,apricots,cherries." (Note: Don't use spaces after commas.)

4.By default, the cells you selected will contain an arrow button which, when clicked, will display the dropdown list. If you don't want the cells to display the arrow button, uncheck the checkbox that says "Display in-cell button to show list.”
5.Click Save. The cells you chose to validate will now display a dropdown list with permitted values whenever a user edits the cell.

By default, people are allowed to enter data in a cell that doesn’t match one of the items on the list. If they do, they’ll see a warning. If you want to be more strict and allow people only to enter information from the list, choose "Reject input" next to the "On invalid data" option.

for reference
https://support.google.com/docs/answer/186103?hl=en

Regards
Rob4077Author Commented:
That's what I did in MS Excel to create it but there doesn't appear to be a Data menu on my Google Sheets on the phone. What am I missing?
Rgonzo1971Commented:
I suppose Google sheets cannot extract the information from excel
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Rob4077Author Commented:
Looks like it's been an issue for 3 years and Google simply aren't capable of getting it to work on Mobile phones. https://productforums.google.com/forum/#!topic/docs/vo06yeIvYLA
I will have to work on a different platform I guess
Rob4077Author Commented:
Found my solution. Use DropBox with MS Excell instead of Google Drive with Google Sheets and it works the way I want.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rob4077Author Commented:
I researched other web sites and found that Google Drive with Sheets has not been made to handle the functionality I was after. In the process I found a solution that would work
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.