Calculate burn down through the month

frob

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)

Ray Lindstrom

Hi @frob,

Curious... Did you build it yourself, or use the new Agile Project with Effort Burndown template available for download?

https://app.smartsheet.com/r/template-gallery/templates/810c57af-927c-45d9-a750-918daba41809/Agile-Project-with-Effort-Burndown?tg-locale=en_US

All the best,

-Ray