"SUMIFS=" " Circular Reference Error"
Hello,
I figured out how to make work a large formula for =Sumifs. The idea was to add the "target budget" of all projects that would have as Project Manager (PM/RI) "Mari M." and only for the projects that would have an "Status of Request" of ( New, Work in Progress, In Design, In construction, Substantially completed, Punch List). the formula looks like this and it works.
=SUMIFS([Target Budget]:[Target Budget], [Assigned PM/RI]:[Assigned PM/RI], "Mary M.", [Status of Request]:[Status of Request], OR(@cell = "Work in Progress", @cell = "New", @cell = "In Design", @cell = "In Construction", @cell = "Substantially Completed", @cell = "Punchlist"))
I have this formula on a cell that belongs to the " Target Budget " column, and although it works fine, when I try to copy the formula (one cell under) and change the "PM/RI" for a different person it blocks my first formula and on the second one it shows me "Circular Reference".
what is the solution for it? so I can keep applying the formula for the next 6 PM/RI
Thanks!
Comments
-
Hi,
You can't have the formula looking at the same range as to where the formula is placed, that's why you're getting the CIRCULAR REFERENCE error. You have to either add or move the formula to another column or limit the referenced range and place the formulas outside of it.
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 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
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!