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
Thanks
Comments
-
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
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!