Microsoft Forms and smartsheet column types
I used to use Formstack but my company is switching over to Microsoft Forms. I'm having an issue where I get a Microsoft Flow error message when I try to map the Forms Timestamp to a smartsheet column that is "Date" format. This is the error message I get:
"The value for cell in column 6900857162753924, 4/10/2020 12:14:09 PM, did not conform to the strict requirements for type DATE."
So I need to have the mapped column by text/number instead of date.
The issue I am having is that I want to automate alerts when it has been over 1 day since the timestamp (and a conditional statement), but I can't do a smartsheet workflow based on Date if the column is text/number.