Joining cells and adding an IF condition
Hello!
I am joining cells by using the + :
=[Select 1535 Levante Equipment]@row + [Select 1551 Brescia Equipment]@row + [Select 1552 Brescia Equipment]@row + [Select 6565 Red Road A Equipment]@row + [Select 6565 Red Road B Equipment]@row + [Select 6565 Red Road C Equipment]@row + [Select 6565 Red Road D Equipment]@row + [Select Architecture 48 Equipment]@row + [Select Architecture 49 Equipment]@row + [Select Casa Bacardi Equipment]@row + [Select Flipse Equipment]@row + [Select Lau Founders Hall Equipment]
But now I want to add that if this equals "Other", I need it to add in the cell called "Zone 2- Other Equipment"
Not sure if that makes sense, but I could use some help!
Thank you!
Best Answer
-
You cannot put the formula into a column that is being referenced by the formula.
Answers
-
Are you able to provide a screenshot?
-
Hi Paul!
Ok so here is my Sheet:
In "Equipment Zone 2" I am joining all the equipment cells by using the "+":
Which is working fine, but when the select "other" for the equipment in goes into the Zone 2 - Other Equipment" cell:
WHat I want to do is if in the cell "Equipment Zone 2" Other is selected that I can add to that formula to pick up the data in the cell "Zone 2 - Other Equipment".
I'm not sure if I am explaining myself correctly or not.
Thank you!!
Lizzy
-
In that case you would want to use something along the lines of...
=current_formula + IF([Equipment Zone 2]@row = "Other", [Zone 2- Other Equipment]@row)
-
Hey @Paul Newcome!
I tried that but I get #CIRCULAR REFERENCE, here is the formula:
=([Other - 1535 Levante Equipment]@row + [Other - 1551 Brescia Equipment]@row + [Other - 1552 Brescia Equipment]@row + [Other - 6565 Red Road A Equipment]@row + [Other - 6565 Red Road B Equipment]@row + [Other - 6565 Red Road C Equipment]@row + [Other - 6565 Red Road D Equipment]@row + [Other - Architecture 48 Equipment]@row + [Other - Architecture 49 Equipment]@row + [Other - Casa Bacardi Equipment]@row + [Other - Flipse Equipment]@row + [Other - Lau Founders Hall Equipment]@row + [Other - McKnight Equipment]@row + [Other - Newman Alumni Center Equipment]@row + [Other - Orovitz Equipment]@row + [Other - Pick Hall Equipment]@row + [Other - Rainbow Equipment]@row + [Other - Studio Arts Bldg. Equipment]@row + [Other - Cox Science Annex Equipment]@row + [Other - Cox Science Bldg. Equipment]@row + [Other - Daner Law Library B Equipment]@row + [Other - Dooley Bldg. C Equipment]@row + [Other - Music Administration Center Equipment]@row + [Other - Pentland House 34 Equipment]@row + [Other - Perez Architecture Bldg. Equipment]@row + [Other - Rehearsal Center Equipment]@row + [Other - Richter Library Equipment]@row + [Other - Silvers/Rubenstein (E) Equipment]@row + [Other - Ungar Equipment]@row + [Other - Volpe Classroom Equipment]@row + [Other - Weeks Center for Recording Equipment]@row + [Other - Weeks Music Library & Tech Ctr Equipment]@row + [Other - Foster Practice Bldg. EQuipment]@row + [Other - Frost North Studio Equipment]@row + [Other - Frost South Studio Equipment]@row + [Other - Gusman Concert Hall Equipment]@row + [Other - Herman Ring Theatre Equipment]@row + [Other - La Gorce House Equipment]@row + [Other - Law Classroom Bldg. F Equipment]@row + [Other - Messinger Music Executive Bldg. Equipment]@row + [Other - Meyer Law Administration A Equipment]@row + [Other - Meyer Law Library D Equipment]@row + [Other - Meyer Law Library G Equipment]@row + [Other - Miller Build Lab Equipment]@row + [Other - Murphy Design Studio Equipment]@row + IF([Equipment Zone 2]@row = "Other", [Zone 2- Other Equipment]@row))
-
You cannot put the formula into a column that is being referenced by the formula.
-
Got it. What I think I'll do is add another column and do =IF([Equipment Zone 2]@row = "Other", [Zone 2- Other Equipment]@row, [Equipment Zone 2]@row).
Thank you for your guidance!
-Lizzy
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!