Automation Based off a Formula Column Not Working


Hello! I have set up the automation below:

The Column that triggers the automation "SKU Created in NS" is an Index/Match formula.

=INDEX({PO Request Form Range 1}, MATCH(Project@row, {PO Request Form Range 2}, 0))

My automation is not working when the box changes to "checked" based on activity in the other sheet. Is this a limitation in Smartsheet? If so, is there a workaround?

Essentially the task "Enter SKU in NS" is needed to track overall progress towards a product launch, but the task is already triggered in another sheet when a PO is requested. I want to avoid having the owner of the task check that they have created the SKU in NS on 2 different sheets.

Appreciate your help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!