I have a column called "order number" in a sheet. At the start of a day, the value in that cell would be 1. How do I make something that will set the value that every time the cell is cleared, the number increments by 1?

CodePudding user response：

I assume you mean a cell as A1. You may want to use B1 as a store cell and coloring the text white (hide your storage value/number of edits).

I built a sample here: