# IF(AND( and IF(OR(

edited 12/09/19

Hi All!

I feel like I have been reviewing every community post about the IF(AND and IF(OR statements within a function but still can't seem to figure out what I am doing wrong.

=IF(AND([Resolution Method]3 = "ClinOps F/U", [ClinOps Resolution Description]3 = "", IF(OR([Additional ClinOps F/U Needed?]3 = "Y", "Yes", ""))))

where if Resolution Method is ClinOps F/U and the ClinOps Description is blank OR the Additional ClinOps F/U is marked "Y" show "Yes" in the cell.

I hope someone has a simple solution because I feel like I have tried it all and it has to be something silly.

Tags:

• ✭✭✭✭✭✭

Try separating each portion out. It makes it easier (sometimes) to just write it out exactly how you would in regular sentence structure.

=IF(

AND([Resolution Method]3 = "ClinOps F/U",

OR([ClinOps Resolution Description]3 = "", [Additional ClinOps F/U Needed?]3 = "Y")

, "Yes", "")

.

Gives you:

=IF(AND([Resolution Method]3 = "ClinOps F/U", OR([ClinOps Resolution Description]3 = "", [Additional ClinOps F/U Needed?]3 = "Y"), "Yes", "")

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!