Formula not working
I would like my cell to look at a cell@row to see if it = 1, or if another cell = minus 150. If either one of those is true, "1", if not " "
=IF([Minus 180]@row = "1", OR([Incremental Start]@row = "Minus 150", "1", " "))
Best Answer
-
=IF(OR([Minus 180]@row = "1", [Incremental Start]@row = "Minus 150"), 1, " ")
With Smartsheet, your combine the IF(OR(AND before you make their arguments and then you separate those statements with commas
Lisa Kennedy
Senior Consultant | Smartsheet Development
Email: info@primeconsulting.com
Lisa Kennedy
Senior Consultant | Smartsheet Development
Prime Consulting Group
Email: info@primeconsulting.com
Answers
-
=IF(OR([Minus 180]@row = "1", [Incremental Start]@row = "Minus 150"), 1, " ")
With Smartsheet, your combine the IF(OR(AND before you make their arguments and then you separate those statements with commas
Lisa Kennedy
Senior Consultant | Smartsheet Development
Email: info@primeconsulting.com
Lisa Kennedy
Senior Consultant | Smartsheet Development
Prime Consulting Group
Email: info@primeconsulting.com
Help Article Resources
Categories
Check out the Formula Handbook template!