IFERROR Problems
I am trying to enter a formula that returns a 1 or 0 if the word "accepted" is in a reference cell. I am ultimately trying to run this formula for 3 separate cells, and if the sum of those cells is 3, then the general status column would turn to "Complete" and Health would turn to Green. Here is the formula I found, but it does not seem to work.
=IFERROR(IF(SEARCH("Accepted",[Signed Subcontract / PO Status]2),1),0)
I have also tried the following:
=IF(ISNUMBER(SEARCH("Accepted",([Signed Subcontract / PO Status]2)),"1","")
=IF(AND(LEFT([Signed Subcontract / PO Status]2)="Accepted","1"
=IFERROR(IF(SEARCH(“Accepted”, [Signed Subcontract / PO Status]2,1)>0,1,0),””)
=IFERROR(SEARCH("Accepted", [Signed Subcontract / PO Status]2:1, 2, false), " ")
Best Answer
-
If you really want to use the IFERROR formula and it would not be affected by the 3 other cells mentioned: =IFERROR(IF([Signed Subcontract / PO Status]@ROW="Accepted",1,0),"")
You could just use: =IF([Signed Subcontract / PO Status]@ROW="Accepted",1,0)
Answers
-
If you really want to use the IFERROR formula and it would not be affected by the 3 other cells mentioned: =IFERROR(IF([Signed Subcontract / PO Status]@ROW="Accepted",1,0),"")
You could just use: =IF([Signed Subcontract / PO Status]@ROW="Accepted",1,0)
-
The second one worked great! I guess I was trying too hard. Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!