If multiple cells are blank or a one specific cell has data


I am trying to achieve this - If the action required by and the data processed is blank or the action required by = "DAT", then "DAT" is the correct response.  

This what I have come up with  =IF(OR(AND(ISBLANK([Action Required by]1), ISBLANK([Data Processed]1)), ([Action Required by]1=DAT)), "DAT")

Am not sure how to fix



  • Shaine Greenwood

    Hello Sally,

    Looks like you're missing the quotes around one of your DAT values.

    Try this formula:

    =IF(OR(AND(ISBLANK([Action Required by]1), ISBLANK([Data Processed]1)), ([Action Required by]1="DAT")), "DAT")

    Quotes always go around text strings, whether your formula is looking for a string, or returning a string.

    Let me know if that doesn't work.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!