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)

Find more posts tagged with

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.