IF/OR/AND Statement

Options

Hi I'd like to do a OR statement with 2 and Statements included - following formula is resulting in an error and I can' see why:

=IF(

OR(

AND([Due Time]@row = "EoD", [Needs Removing]@row = 0),

AND(Status@row = "Not Started", Done@row = 0),

"1", "2"))

Can some please take a look over it and advise why and amend.


Many thanks in advance.


Mike

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!