Current Year Specific month formula, need assistance please.
I am trying to modify a formula written by someone else that is looking in the current year for open quotes that are not closed prior to the month being pulled or have no closing date. I need to do this for each month individually for graphing our sales pipeline. The numbers are not accurate and almost appear to add over time. This is the current formula being used, would this be accurate for August?
=SUMIFS({Total}, {Quote Date}, <DATE(YEAR(TODAY()), 9, 1), {Close Date}, >DATE(YEAR(TODAY()), 9, 1)) + SUMIFS({Total}, {Quote Date}, <DATE(YEAR(TODAY()), 9, 1), {Close Date}, ="") + SUMIFS({Total}, {Quote Date}, ="")
Answers
-
This formula is going to add together anything in the {Total} range that has a Quote Date less than 09/01 of the current year and a Close Date greater than 09/01 of the current year. Then it's going to add that total to anything in the {Total} range that has a Quote Date less than 09/01 of the current year and a Close Date that's blank. Then it's going to add to it anything in the {Total} range that has a Quote Date that's blank.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!