Help with a formula to sum the hours by month by project
Hi all - I need some help building a formula that will show the sum of hours by month (see attached summary sheet - columns Jan 2021 Hours / Feb 2021 Hours) by project. The data that it needs to sum is on the Time Tracking Entry sheet. The unique identifier on both sheets is the "ID". Thanks in advance for any help you can provide.
Tags:
Answers
-
Hi @Jen Iliff
Hope you are fine,please try the following formula
=SUMIFS({Hours}, {ID}, ID@row, {Today's Date}, MONTH(@cell) = 1)
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K 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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!