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
Is there a way to add a logo to an automation email? I'm worried that it might look like junk mail and someone won't read it. I have a Business account, if that makes a difference.
Hi, My organization needs clarification about the new USM before we run into issues at renewal. User experience is welcomed, but we also need this info from an employee. Can internal viewers remain viewers and still- Submit Update and Approval Requests sent to them? Will comments remain a field that can be included in…
I created a report to try and get all my projects tasks organized and identifiable by project. I have the report groups by work breakdown schedule sheet, but for some reason my latest sheet will not break out in its own group. in the image below you can see the sheet that is grouping is the template sheet, but the P-0100…
