Automation where condition pulled in via Index(Match)
I'm trying to get an automation to run where the condition is based on a column not being blank but that column gets filled in via an Index(Match) formula and I think because of this, the cell is always showing as blank when triggered and so it is automatically going to the "otherwise" condition despite "1st Approver" column not being blank. I'm trying to figure out either a way to restructure my automation or something else. Any thoughts?
Help Article Resources
Check out the Formula Handbook template!