Earliest Start date on a smartsheet Form

Melanie Woods

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.

Summer

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

Melanie Woods

Clarifying question...Will this show up in the form since it has not been created?

Summer

No the "Created" System column will not show up in the form.

https://help.smartsheet.com/articles/1964567-system-columns

Summer

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.

Melanie Woods

Yes. So it is the earliest start date that we can provide service.