I've created a form using Survey123 Connect that features a date entry (as type) with a default of today()...for example it would populate the form with Thursday, February 27, 2020. Today's date.
As an fyi...I added a new row just below this one (text as type) to reformat this date...for example the new date format is illustrated as 02/27/2020. In using Google Sheets in tandem with Integromat it is necessary that the date be represented as such or you get a very strange entry. Anyway...
Further down in my sheet I have another date entry. I would like to take today's date and automatically populate this entry with a date 1 year out from today.
The auto-populate entry for that date would then read 02/27/2021.
Can this be done?