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
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 146 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!