Hi All,

Need help in fixing Automation workflow which works only if I manually trigger.

Basically, I'm trying to have Manager approve costing again if it's more than the allocated amount.

I've setup 2 helper columns with the following formulas:
=IF([Co-Op Allocation]@row >= [Co-Op Actual]@row, "0", "1")
=IF([Markdown Allocated]@row >= [Markdown Actual]@row, "0", "1")

Then created following automation workflow, which doesn't work when help column value change to 1. However, this works if I trigger manually and not showing any error.

Trigger: When rows are added or changed.
When: Helper-Column-Co-Op changes to: 1
or when: Helper-Column-Markdown changes to: 1

Alert someone: Send to contact in a cell "Direct Manager"
Change cell value: Direct Manager Approval to " Please re-approve"
(Direct Manager Approval column is drop down and has 2 values (Approved / Please re-approve)

Please note user have to enter actual amount manually.

Thanks in advance,