Need a formula, automation is able to do my task


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.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!