Graphing Sumif Data for Date Specific Criteria
Hi Newbie here...
My first attempt at creating a graphical / chronological representation of Date specific ALLOCATION subtotals has resulted in an #invalidoperation message.
Goal is to show Users combined ALLOCATION on the Y-axis over time increments (wks, mo, etc.)
I'm sure you guys have already done this one so any help would be much appreciated!
The graphical part is easy and has already been achieved with dummy data, its the formula (or alternative approach) i'm grappling with which i'm pulling from my workspace.
=SUMIFS({SoCal Precon Workspace Range 3}, {SoCal Precon Workspace Range 5} = RESOURCE3, {SoCal Precon Workspace Range 4}, >=7 / 1 / 2019, {SoCal Precon Workspace Range 1}, <=7 / 31 / 2019)
Thanks in advance!
Comments
-
Just a couple of minor tweaks...
1. You are missing a comma between your first range and criteria.
2. When using a date in a formula, you need to use the DATE function: DATE(yyyy, mm, dd)
.
=SUMIFS({SoCal Precon Workspace Range 3}, {SoCal Precon Workspace Range 5}, = RESOURCE3, {SoCal Precon Workspace Range 4}, >= DATE(2019, 7, 1), {SoCal Precon Workspace Range 1}, <= DATE(2019, 7, 31))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!