Conditionally changing cells


I'm looking to see if there is any formula(or anything else) I could use to change a cell to a specific pre-defined value, if a different cell is CHANGED TO a certain value.

I know that the changed to functionality is available through automation, however the action options in automation do not offer cell changing functionality.

If this is unclear please feel free to ask me to elaborate.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!