Joining cells and adding an IF condition

Hammermill21

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!

Paul Newcome

You cannot put the formula into a column that is being referenced by the formula.

Paul Newcome

Are you able to provide a screenshot?

Hammermill21

@Paul Newcome

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

Paul Newcome

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)

Hammermill21

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))

Paul Newcome

You cannot put the formula into a column that is being referenced by the formula.

Hammermill21

@Paul Newcome

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