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.
Any advice?
Answers
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives