Autocrat Date Generation

[Guest Experience]

Hello All,

I am currently using Autocrat do generate a speradsheet from a google form. FOr the most part it works great, however, the dates are being geenrated in a numerical format (11/07/2022) where I am looking for the format July 11, 2022. Is there any way to change this? I have tried playing with multiple settings in the form, and it will change the format for dates already in the spreadsheet, but not new ones which come in. 

Also, we have to generate a second column which creates a date 3 months from the first column ( example July 11, 2022 ---> October 11, 2022). Is there any way to create this, using the same format?

I hope somebody can be of assistance.

Thanks,

Anthony

[Joseph Schmidt]

You can try the CopyDown Add-on to copy the format to each new row that is added.

You can add a column to calculate the date by using the Edate function.  

You can use the Text function to create text in a new column in any format you want.  Sometimes date formats get changed by Autocrat.  Using Text Autocrat uses what it sees.

I like the arrayformula instead of copydown to get the formulas in each row.  See Arrayformulas

I love it.  Payments are calculated weekly at your website.  Soon it will be daily.

Joe Schmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/9c3e03f3-5edd-4792-91ad-c0d1cce63b16n%40googlegroups.com.