Add new row with next day automatically

1

Is there an easy way to automatically add the date for the next day of the row above. in other words, I start with April 3, 2024. When I add a new row, I want the date Column to be filled out automatically with April 4, 2004, etc.

2

Hi @juergenheise,

that is not a big thing.

There you go:

AddRow(thisTable, thisTable.Date, thisRow.Date + Days("1"))

Please let me know if that fits your use case.

Sincerely
Jannis

3

Thank you for your help.

1 Like
4

I would put the following formula in the value for new rows option:

image

2 Likes