Permantly update cell with IF function


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!