Changing Status Based on Another Sheet


Is there a way to link a cell from sheet A to respond to a change in Sheet B?

For example, if I change a cell in sheet B to "under review by editor" could I change a corresponding cell in sheet A to "In Edits"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!