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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!