Default dates on web form

Kevin Caldwell

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?

Shaine Greenwood

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