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)