Need a formula, automation is able to do my task

Options

When Assigned To changes in Task that contains "CCM Initial Checkout"(row 4) change Status in Row 3 to "Completed".

I only need it for these rows/cells, cannot have the entire column doing this.

TIA!!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!