Formula for if Blank

Hi,

I am trying to get the formula to return "Report not Received" when a cell is left blank. I have tried numerous was and am not receiving the result I am looking for.

It will either return a "Report Received by Deadline" or will remain blank.

Here is the current formula:

=IF(NOT(ISBLANK([January '22]@row)), IF([January '22]@row > DATE(2022, 1, 31), "Report Received After Deadline", IF([January '22]@row <= DATE(2022, 1, 31), "Report Received by Deadline")))


Answers

  • Christian G.
    Christian G. ✭✭✭✭✭✭

    =IF(NOT(ISBLANK([January '22]@row)),IF([January '22]@row > DATE(2022, 1, 31),"Report Received After Deadline",IF([January '22]@row <= DATE(2022, 1, 31),"Report Received by Deadline")),"Report not Received")

    In your initial If statement, you are defining what to do when the cell is "Not Blank", but you forgot to tell what to do when the cell is blank. Here is another way to write the same formula:

    =IF(ISBLANK([January '22]@row),"Report not Received",IF([January '22]@row > DATE(2022, 1, 31),"Report Received After Deadline",IF([January '22]@row <= DATE(2022, 1, 31),"Report Received by Deadline")))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!