Permantly update cell with IF function

Gabe Raichart

Hey all,

Im trying to update a cell based on another cell and so far i have this

=IF(Status1 = "Laser", "1")

This works great but the cell doesn't stay updated when I change status, which makes sense, but I need it too. Ive tried

=IF(Status1 = "Laser", [Laser-Meta]1 + "1")

as to append to the cell and this

=IF(Status1 = "Laser", "1", IF([Laser-Meta]1 = "1", "1"))

as to check if its set to 1 before updating the cell again. Thanks for the help

L_123

The only way I know is to use two sheets to do this. Use your first formula, then use a copy workflow that says if updated cells change, copy it to another sheet. If you want to get fancy you can copy it back into the original sheet with a workflow on that sheet as well. When the rows get copied, the formulas get changed into static values, which means you will retain your information.