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 dates on web form
Hello All,
I use smart sheet as project list and a web form as a work request. Our policy is that all request need to be submitted 4 weeks prior to their due date. Is there a way to have the duedate field on my webform defaut 4 weeks out from the date the form is accessed?
Comments
-
Hello Kevin—there isn't a way to set a default due date in a web form, but you might consider placing a formula in your due date column that adds 4 weeks to the start date, and excluding that due date column from your web form to prevent users from manually entering a date. An example of what the formula might look like is as follows:
=[Start Date]1 + 28
Note that formulas can't be placed in dependency enabled start and end date columns.
If needed, details on using Web Forms and formulas can be found in our Help Center:
Web Forms: http://help.smartsheet.com/articles/522221-using-web-forms
Formulas: http://help.smartsheet.com/articles/775363-using-formulas
