I want to make a widget with hours consumed.
Hello!
So, I want to make a Widget in my dashboard that shows that hours consumed by my resources out of their allocated hours, for that i need to SUM all the hours they put on their TIME ENTRY sheet, i made the formula and in works on SHEET SUMMARY being =SUMIFS(HOURS:HOURS, EMPLOYEE:EMPLOYEE, "xxxxxxx") (xxxxxx being the actual name of the person) BUT in order to make a widget i need to create a new sheet with only the data a need, that being:
- the sum of hours that each resource has put on their sheet table which i got the number with the formula above.
- the allocated hours which i get from the PP
My problem is when i copy my formula to my new sheet and reference the TIME ENTRY sheet it doesnt work, and i dont know why, the formula i use is =SUMIFS({NAME OF THE SHEET Range 5} HOURS:HOURS, EMPLOYEE:EMPLOYEE, "xxxxxxx")
This are the widgets i need to make
This is the formula thats working of the Time entry sheet but it doesnt work on a new sheet with reference to this sheet.
Please Help!
Thank you.
Answers
-
Hi, you would have to reference the range for [employee]:[employee] in the new sheet as well,
the formula would look something like
=sumifs({range 1},{range2},"[primary column]@row")
The area selected upon clicking 'reference another sheet' is the equivalent of [hour]:[hour]
you would not see the actual column name of the original sheet.
do let me know if that helped
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
- 146 Just for fun
- 63 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!