Microsoft Forms and smartsheet column types

Julia C Peterson
Julia C Peterson ✭✭✭✭
edited 06/14/22 in Add Ons and Integrations

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.

Any advice?