Can someone please take a look at this formula to see what I'm doing incorrectly?

asimcock

=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!

Ashley

Paul Newcome

Give this a try (make sure parenthesis are all in place):

=IF(ISERROR(Approver@row), "Outstanding Action", "Action Complete")

Samuel Mueller

@asimcock, try this,

=IF(NOT(iserror(Approver@row), "Action Complete", "Outstanding Action")

asimcock

Hi @Samuel Mueller thanks for the formula, the hiccup I'm running into is that the text in the column I'm searching for must have the text "#NO MATCH" in order for me to determine if the action was taken. The above formula unfortunately didn't work. I then tried adding the not equal section in as well and that didn't work either

=if(isnot(Approver@row="#No Match", "Action Completed, "Outstanding Action")

the end result I'm hoping for is that if the reference cell is #NO MATCH the Status will be "Outstanding Action" and if the reference cell has a person's name in it, it will say "Action Completed".

Thanks for taking a look!

Paul Newcome

Give this a try (make sure parenthesis are all in place):

=IF(ISERROR(Approver@row), "Outstanding Action", "Action Complete")

Samuel Mueller

@Paul Newcome thanks for the parenthesis catch 😁

asimcock

@Samuel Mueller and @Paul Newcome thank you both so much for your help! That worked :)

Paul Newcome

Happy to help. 👍️