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!
Ashley
Best Answer
-
Give this a try (make sure parenthesis are all in place):
=IF(ISERROR(Approver@row), "Outstanding Action", "Action Complete")
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
@asimcock, try this,
=IF(NOT(iserror(Approver@row), "Action Complete", "Outstanding Action")
-
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!
-
Give this a try (make sure parenthesis are all in place):
=IF(ISERROR(Approver@row), "Outstanding Action", "Action Complete")
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Paul Newcome thanks for the parenthesis catch 😁
-
@Samuel Mueller and @Paul Newcome thank you both so much for your help! That worked :)
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!