Need a formula to copy contact name from cell when criteria is met in another cell


When the "Assigned To" (Assignee 1) in row 1 checks "Completed" copy "Successor" (Successor 1) in row 1 to "Assigned To" in row 2. Then I will create an automation to notify the new "Assigned to" in row 2 that the task is now assigned to them. The end goal is to create an automated process that moves through the project tasks without project manager involvement. Our team tracks their work on individualized sheets pulling tasks assigned to them from all active sheets. So, I'm trying to avoid tasks populating their individual sheets before they can work on them.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!