Default form date to Today + constant

Ian Wallace

I am creating a form that un licensed users will use to submit requests.  I want the default for the form to be Today + 4 business days.  Is this possible? It looks like the default date can either be hard coded to a specific date, or set to Today.  Any help would be appreciated!

Shaine Greenwood

Hi Ian,

Although you can't put a formula in the form, you can put your formula in the sheet directly in a date column. I'm assuming that you want to have a date that's 4 days from the date they submitted—I think the best way to do this is as follows:

• Create a Created (Date) System Column in your sheet. This will track the date they submitted via the form.
• Create a Date Column in your sheet. This will be where your formula adds the 4 days.
• In your Date column, create a formula that takes the date from the System Column and adds 4 days, e.g.: =WORKDAY(DATEONLY([My System Column]1), 4)
  
  
  
  To break that formula down: WORKDAY make sure you're only returning business days and DATEONLY extracts the date portion from your system column.

J. Craig Williams

Shaine,

=WORKDAY(DATEONLY(Created23),4)

and

=WORKDAY(Created23,4)

return the same value. I have still found no use case for DATEONLY() since the change last year.

Craig

Shaine Greenwood

Maybe I'm a creature of habit.

J. Craig Williams

Aren't we all? LOL

J. Craig Williams

See my new post:

http://ronin-global.com/2018/07/20/defaulting-to-a-date-in-a-smartsheet-webform/

You can change the TODAY() to TODAY(4) to get the results you are looking for.

Craig