Form date field settings
On SmartSheet forms is there a capability to set a timeframe for the default date used in a date field, rather than using an exact date? For example, we'd like to set it for something like "10 days in future" so that the default date field would always be a future date that would align with our standard lead times. Right now if we don't continue to go in and update it periodically, some people will just use the default date, disregarding the fact that the date is in the past.
Answers
-
Cant do this on a form. Are you trying to do something like due date + 10 days or submitted date + 10 days?
-
Thanks for the response. Yes, that's exactly what we'd like to set up for that date field.
-
So you can add a column with a column formula: =today()+ 10
The issue is that this date moves every day. If you have datamesh, you can bring in this date as a one time write when a row is added. probably more details to discuss through but directionally there is a way to do this.
