Store maximum value in a cell
I have a spreadsheet that pulls the current stage (numbers 1-5) of several projects. If the project is terminated it goes back to 0. I want to be able to store the last stage reached before it was terminated (i.e. changed to 0). How could I do this?
In excel I would typically use a self-referencing cell, for example on cell B1 I would input the following formula =if(A1=0,B1,A1). So if the value of A1 is changed to 0, the current value of B1 is stored (i.e. last value of A1 before it was 0). This creates a circular reference which is not allowed in smartsheets.
Help Article Resources
Check out the Formula Handbook template!