If today is less than end of month dont calculate

Options

Hello,

I have a formula I am working on to identify if a report was received on time, late, or not at all, however, I do not want it to calculate if todays date is less than the last day of that month. For example, for November, since today is 11.22.22, it would return blank since today is less than 11.30.22. However, it should apply the formula once 11.30.22 is reached.

In the example I provided it is for October, so the remainder of the formula should apply since todays date is greater than 10.31.2022, however all cells in the Oct '22 Status column are returning blank.

=IF(TODAY() < DATE(2022, 10, 31) = "", IF([October '22]@row = "", "Report not Received", IF([October '22]@row <= DATE(2022, 10, 31), "Report Received by Deadline", IF([October '22]@row > DATE(2022, 10, 31), "Report Received After Deadline"))))


Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Options

    @CaraBart28

    Your formula starts off with an error in the first IF statement. Instead of = "" you need to do this:

    =IF(TODAY() < DATE(2022, 10, 31), "", IF([October '22]@row = "", "Report not Received", IF([October '22]@row <= DATE(2022, 10, 31), "Report Received by Deadline", IF([October '22]@row > DATE(2022, 10, 31), "Report Received After Deadline"))))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!