Working on a budget & tracking base which has several phases (Not-Submitted, Submitted, Executed, Reconciled)
Trying to find a way to “lock” a value (i.e. grab the value of a cell when the checkbox is checked). Goal is to take the values when they are submitted and use them in the “executed” phase of the table without them ever changing.
I build an order, then set the status to “submitted,” I’d like a new column to take the total of the order when I clicked “submitted” so that I can track performance.
Any help is greatly appreciated!