Formula Returns Blank Result

Options

Hi all,


Please can someone help. I have a formula that has worked every day up until today (Thursday). Can anyone spot what I am doing wrong?


=IF(WEEKDAY(TODAY()) = 2, COUNTIF({Date Received}, TODAY(-3)), IF(WEEKDAY(TODAY()) = 1, COUNTIF({Date Received}, TODAY(-2)), IF(WEEKDAY(TODAY()) = 7, COUNTIF({Date Received}, TODAY(-1), IF(WEEKDAY(TODAY()) = 4, COUNTIF({Date Received}, TODAY(-1), IF(WEEKDAY(TODAY()) = 3, COUNTIF({Date Received}, TODAY(-1)), IF(WEEKDAY(TODAY()) = 5, COUNTIF({Date Received}, TODAY(-1)), IF(WEEKDAY(TODAY()) = 6, COUNTIF({Date Received}, TODAY(-1)))))))))))


Thanks,


Meg

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!