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!
Best Answer
-
@Hannah Gray Cross Sheet formulas cannot trigger workflows.
I understand that this quirk is mentioned in a Move/Copy help article, but essentially changing a cell value is is considered a "change in a sheet".
"To prevent infinite approval loops, cells which containย cross-sheet formulasย orย cell linksย wonโt trigger an automation that automatically changes the sheet (Move Row, Copy Row, Lock Row, Unlock Row, or Approval Request). To work around this, consider usingย time-based automationย orย recurrenceย workflows."
Answers
-
@Hannah Gray Cross Sheet formulas cannot trigger workflows.
I understand that this quirk is mentioned in a Move/Copy help article, but essentially changing a cell value is is considered a "change in a sheet".
"To prevent infinite approval loops, cells which containย cross-sheet formulasย orย cell linksย wonโt trigger an automation that automatically changes the sheet (Move Row, Copy Row, Lock Row, Unlock Row, or Approval Request). To work around this, consider usingย time-based automationย orย recurrenceย workflows."
Help Article Resources
Categories
Check out the Formula Handbook template!
