Auto populating dates in pre-filled tables is useful when you're logging rows and you want a fixed number of days added from the previous log. This is only applicable to prefilled tables as you need a date guide for your formula.
Before setting up the formula, you'll need to ensure you're using a 'prefilled table' by navigating the cursor to the left tab and clicking 'Prefilled table' under 'Table'.
Set the first row of your date cell as a 'Date Field'. Set second row date cell as a 'Formula field' as shown (for example).
Date Field | - | - |
Formula field for date | - | - |
To autopopulate dates, use TEXT() in the formula field for date:
=TEXT(A1+Number,"DD/MM/YYYY")
Note: Dates are stored numerically and need to be surrounded by TEXT() to show a date format
where 'Number' is a constant you set
Note: You can copy off the formula in the display date cell by clicking '+ Add row' in the table.
For example, if you want to auto populate the next date (+1 day), use the formula:
=TEXT(A1+1,"DD/MM/YYYY")