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?

Tags:

Answers

  • Paul Newcome
    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.

    thinkspi.com