Can someone please take a look at this formula to see what I'm doing incorrectly?
=IF(NOT(Approver@row = "#NO MATCH"), "Action Complete", "Outstanding Action")
The result of the above equation is that if the data check is not "#NO MATCH", the result properly lists "Action Complete". However, if it is #NO MATCH I would like it to say "Outstanding Action" and that is not happening with this formula.
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!