Microsoft Forms and smartsheet column types

Julia C Peterson

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?

Paul Newcome

You could create a column in the sheet itself that logs when the row is created, or you can use a formula to pull the date from the text string and convert it to a date value into a date type column that can be used in the Alert.