SUMIFS or SUM(COLLECT) With Cross-sheet Reference
I'm trying to total up hours from a timesheet for each individual across multiple projects. I've tried the following two formulas but both are returning 0.
SUMIFS({Timesheet Hours}, {Timesheet Name}, [Resource Name]@row, {Timesheet SOW}, SOW@row)
=SUM(COLLECT({Timesheet Hours}, {Timesheet Name}, [Resource Name]@row, {Timesheet SOW}, SOW@row))
Best Answer
-
Found my issue. I needed an = before [Resource Name]@row and SOW@row respectively.
Answers
-
I had a similar issue where I needed to convert timesheet hours to a value. Basically whatever formula you have calculating the timesheet hours surround it with a =value(.....).
Does that fix the issue?
-
Then use the sumifs formula that you already made.
-
Unfortunately not. The Hours and SOW columns from each sheet are both Text/Number fields while the Name columns are Contact List.
-
Found my issue. I needed an = before [Resource Name]@row and SOW@row respectively.
-
Ah good catch
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!