I have 2 sheets that are communicating successfully. Sheet A has a column called "Application Status" that displays a red, yellow, or status green ball depending on a formula that references Sheet B:
=IF(INDEX({Sheet B-RoutingProgress}, MATCH([Project #]@row, {Project#}, 0)) = "Yellow", "Yellow", IF(INDEX({Sheet B-RoutingProgress}, MATCH([Project #]@row, {Project#}, 0)) = "Green", "Green", "Red"))
This formula works fine -- the colors change as they should depending on what's going on in Sheet B.
My problem is that there is a Move Row workflow built into Sheet A that says that when "Application Status" changes to "green," that row should move to Sheet C. This isn't happening. Everything with the workflow is simple and appears to be in order (see screenshot below) which makes me think that for some reason the workflow isn't seeing the "Application Status" as "green" even though it's correctly displaying that way, based on the formula. (Could it be because the content of that cell actually never changes, because it's a formula?)
Thoughts?
