How to restart a sequence of numbers?

[Oldsoul]

Hi everyone!

Would greatly appreciate guidance for the date/time type and sequence numbering.

I’m aware that the sequential numbers are an issue on appsheets but in another post someone shared this expression that actually works:

(MAX(RESOURCES[WATERING]) + 1)

This will return sub-sequential numbers of the maximum value in the column.

What i would like to do is to sequence the waterings of the day, then refresh the count on the next day.
I tried this formula, but the watering numbers wont even change:

If(MAXROW(“RESOURCES”, “Date4”)=DATE([Date4]),(MAX(RESOURCES[WATERING]) + 1),1)

Thanks!