Formula that includes referencing multiple different grid reports and ranges
We are looking for a formula that reference how many items they completed throughout the year, by looking at a persons name. Problem is we have to use multiple grid reports and ranges to find the total of items completed for the year. Does any one know of ways to reference multiple grid reports into one equation. Example equation that doesn't work is below
Answers
-
@jcormican You can't reference ranges from multiple sheets in the same sumifs() function. HOWEVER, you can sum the result from multiple sumIFS() in one cell.
So you can for example:
SUMIFS({criteria for sheet 1}) + SUMIFS({criteria for sheet 2})+….+ SUMIFS({criteria for sheet N})
You'll just sum the matching values from each sheet.
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!