Dynamic Default Date

Carol Ann Lee · 11/04/20

I am trying to set up a default date within a form field to always be today's date + 5 days. For example, I am creating a marketing asset request form. I would like the review date field to default to a 5 day turnaround time, with the option for the requestor to modify the date if needed.

Is there a way to do this?

Andrée Starå · 11/04/20

Hi @Carol Ann Lee

Yes, but you'll need to add it to the sheet and use a so-called helper column.

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Carol Ann Lee · 11/04/20

https://community.smartsheet.com/discussion/comment/267920#Comment_267920

Can you point me to any tutorials for helper columns? Thank you.

Andrée Starå · 11/04/20

@Carol Ann Lee

Happy to help!

A helper column is a column that doesn't have any function except helping with the structure/process. There isn't any documentation.

Let me know if you need any help or if you have any other questions!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Dynamic Default Date

Answers

Categories