SUMIFS FORMULA ERROR: #CIRCULAR REFERENCE #BLOCKED
I have a sheet I am making to track estimated project hours per week/month. The employee is going to fill out one line per project. I want a calculation at the bottom that summarizes the data per month.
My formula is: =SUMIFS([Jan '23 HPW]:[Jan '23 HPW], Resource:Resource, "Austin Merritt")
The Jan '23 HPW column is a Text/Number type and the Resource is a single drop down list.
It works when I have a single entry in the sheet, but the moment I add another line and try to calculate multiple people. (see screen shots below)
Any thoughts?
SINGLE:
MULTIPLE:
Answers
-
@MickeyD Hi, A screen shot of the sheet would help to understand how it was setup. Still I suggest having the calculations in the sheet summary section or in a separate sheet.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!