Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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?
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
