IF/AND/OR Statements Help To Check A Box When Criteria Met

Options

Hi,

I am trying to write a formula with multiple IF statements with OR and AND to check the appropriate box:

I have this so far and get #INCORRECT ARGUMENT:

=IF(AND(NOT(ISBLANK([Term Date]@row))), OR(Program@row = "ABC", [Shared Programs]@row, OR(@cell = "ABC / XYZ", @cell = "XYZ / ABC")), 1, 0)

Thanks for any help offered!

Lori

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!