Joining cells and adding an IF condition

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

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!