IF/OR/AND Statement

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:



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.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!