Is there a way to trigger a workflow following an automated update second request?


I have created a an automated workflow to send update requests 2x if a cell is blank.

I want to create an automated assignment if the cell [Fail1] is not completed within a week after the second update request. Also, Fail1 has a formula to determine if a provider failed given 3 other criteria in other columns.

Is there a way to do this automatically? I am thinking I will need a helper column with a date that is a week after the second update request to trigger the assignment. If I do this, can you help with a formula to create a checkbox that I can use to trigger the assignment? Is it possible to create a formula using a cell with a formula already?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!