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.

Andrée Starå

Hi @Gabe Raichart

This might help.

Please have a look at my post below with a method I developed.

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!