Earliest Start date on a smartsheet Form
We need 2 weeks to provide service to our customers. If they enter information in a form in smartsheet, how do we indicate the earliest date that they can expect service within the form.
So it would be today's date +14 days. Caveat is "Today's date" needs to be static.
Thank you.
Answers
-
You could use the "Created" System column to capture when the form was submitted and then base your 14 days from there.
=(Created@row) + 14
The column with the formula will need to be formatted as a Date column.
That's just straight calendar days. If you want to factor in working days only, you'd need to use a function like WORKDAY, NETWORKDAY or NETWORKDAYS https://help.smartsheet.com/function/networkday, https://help.smartsheet.com/function/workday
-
Clarifying question...Will this show up in the form since it has not been created?
-
No the "Created" System column will not show up in the form.
-
Ah, I see, I misunderstood your ask. You are looking to provide the "Service by" date to the customer when they are completing the form? Is that correct?
At this time Smartsheet does not have the capability to add formulas to the forms.
I would recommend adding in "helper text" to your form letting the submitter know about the 14 day timeline and then still implementing the created by formula to help you keep the timelines aligned in the background.
-
Yes. So it is the earliest start date that we can provide service.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!