Sign in to join the conversation:
Is it possible to prefill dates in forms? I am looking to fill the following in my forms:
Hi,
Unfortunately, it's not possible to pre-fill or calculate dates in the form at the moment, but it's a great idea!
Please submit an Enhancement Request when you have a moment.
As a workaround, you could do the calculation on the sheet instead, but the date will update each time the sheet is opened and saved if we use the TODAY function. The submitter could select today's date, and the rest could happen on the sheet.
Another option could be to use a third-party form solution instead.
Would that work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I have a column in my sheet that auto-populates dates. You may need to manually enter the today date and not sure how you could make it work for the tomorrow's date if submission is after 3pm (again this may need to be manual) however it should work for the 4 days later (not sure about specifying of business days, again may need to add into calculation manually). This is how it worked for me:
Enter this following formula into the cell you wish to be 4 days later:
=[ColumnName][Row#]+[#ofDays]
example: My column named is "Updated". If I want row 5's follow up date to be 30 days after the last "update" date, I use =Updated5+30
If you are adding this column into a already filled sheet you should be able to copy (using the bottom right corner of the cell) the column all the way down, just as you would in Excel.
Hope that helps!
That's actually easy. Just create a automatic column in your underlying smartsheet that captures "Creation Date". That will give you the date that the form is entered.
https://help.smartsheet.com/articles/1964567-system-columns
There is no way to extract the timestamp (that could be a feature request). However, you could change your time zone so that Smartsheet thinks you are 9 hours in the future. That would change your date to the next date. (i.e. go from GMT-5 Eastern to GMT+4 Asia
The you add a date column that adds to your timestamp created date: i.e the formula would be:
=Created1 + 4
Test this out and see if it works for you.
LG
Greetings- I have a automation setup when I select the "status" column drop-down to "completed" I want the row info to be emailed to the contact to submitted it with a follow up then I want it to archive the row (aka move to another sheet). When I run the automation only 1 of the 2 requests happen. The archive happens…
This discussion was created from comments split from: Error Saving a Smartsheet.
I am trying to use the automation template in a work plan sheet, where when I change the project status column to "completed" the "% completed" changes to 100% on the row. I have even tried to reverse it, and say when % completed = 100% change project status to Completed. This seems like a very simple ask, and is a baked…
