Detect Date in Column to enable Date Time Picker

I have a spreadsheet with a column called Date. The user is supposed to be able to edit and enter new dates. The sheet already includes dates such as: 2/2/2019 13:00:00. Yet, the app does not recognize this field as Date Time. I don’t want users to enter dates annually as they will each come up with diffetrent formats.

So, how do I enable the date time picker for this date fields in my app?

What happens when you add the date time picker and point it to that column?

Ah great. Not sure how I missed that. That was it.

1 Like