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.