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!

Tags:

Best Answer

Answers

  • Hammermill21
    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
    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
    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
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

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

  • Hammermill21
    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!