Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Default form date to Today + constant
Comments
-
Hi Ian,
Although you can't put a formula in the form, you can put your formula in the sheet directly in a date column. I'm assuming that you want to have a date that's 4 days from the date they submitted—I think the best way to do this is as follows:
- Create a Created (Date) System Column in your sheet. This will track the date they submitted via the form.
- Create a Date Column in your sheet. This will be where your formula adds the 4 days.
- In your Date column, create a formula that takes the date from the System Column and adds 4 days, e.g.: =WORKDAY(DATEONLY([My System Column]1), 4)
To break that formula down: WORKDAY make sure you're only returning business days and DATEONLY extracts the date portion from your system column.
-
Shaine,
=WORKDAY(DATEONLY(Created23),4)
and
=WORKDAY(Created23,4)
return the same value. I have still found no use case for DATEONLY() since the change last year.
Craig
-
Maybe I'm a creature of habit.
-
Aren't we all? LOL
-
See my new post:
http://ronin-global.com/2018/07/20/defaulting-to-a-date-in-a-smartsheet-webform/
You can change the TODAY() to TODAY(4) to get the results you are looking for.
Craig
This discussion has been closed.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives