Calculate burn down through the month

Hey all,

So I'm trying to create a graph showing the burn down of events we have left to do. Essentially I need my function to go count on "today" and do nothing if it's not today. My code doesn't work as the fuction becomes false the next day. How do I make a function stop if it is false. Or if you all know of a better way to do this I'm open.

=IF(DAY(TODAY()) = Date2, COUNTIFS({01 Current PM Master BEC}, "CD Gateway", {01 Current PM Master Due Date}, {01 Current PM Master Due Date} <= TODAY()), Gateway1)


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!