Changing Status Based on Another Sheet

Options

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"

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!