SUMIF(S) Not Working
Smartsheet community,
I am having trouble with adding up a column of hours based on who the task is assigned to. Ihave a metrics sheet to use to populate the dashboards i have created.
=SUMIFS({BI/BA Team Projects Range 8}, {BI/BA Team Projects Range 1}, Item89)
{BI/BA Team Projects Range 8}= the column the numbers are located in
{BI/BA Team Projects Range 1= Assigned to Column
Item89= the persons name in the metrics sheet.
It was working but now I am getting a circular reference error and I cannot figure out what went on.
Thank you in advance for any assistance.
Answers
-
Hi @Carl Vieira
It looks like you only have criterion that you would like to meet, so would SUMIF better serve you in this case?
What if you were to try:
=SUMIF({BI/BA Team Projects Range 1}, Item89, {BI/BA Team Projects Range 8})
-
@John Jonassen thank you for this but am still getting a #circularreference error message when I use your suggested re-write.
-
@John Jonassen I reformatted my formula in the metrics sheet I created and it worked great!
Thank you!
-
Hi Carl, here is some more information on Circular Reference:
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
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives