Looking for a Sum of a category with Criteria
Hi Everyone,
I am looking for some help with a formula. Looking for a Sum of the hours needed based on who they are assigned to and the particular business unit, that have a status as "Green". Cannot for the life of my figure out how to make it work.
Answers
-
According to your screenshot, if you wanted to sum hours for Kati Fictum, from the Marketing with green status, the formula would be this one:
=SUMIFS([Hours Needed]:[Hours Needed], [Assigned To]:[Assigned To], "Kati Fictum", [Business Unit]:[Business Unit], "Marketing", [Status]:[Status], "Green")
Hope it helped!
-
Hi David!
Thank you for the quick response. I am getting the #UNPARSEABLE error with this :(
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives