Multiple IF Formulas - cannot figure out why it's producing a "0"

Options

Hey all - I'm working on a formula that built as an IF formula. It has multiple "IF" statements, and I'm stumped as to why it's producing a zero (although it's likely because there are too many "IF" formulas) and what to use in leu of this formula.

I want the formula to put out an abbreviation based off the team name - this is a helper row for an overall larger formula.

Here is the formula: =IF([Team Name]@row = "Team 1", "(" + "T1" + ")") + IF([Team Name]@row = "Team 2", "(" + "T2" + ")") + IF([Team Name]@row = "Team 3", "(" + "T3" + ")") + IF([Team Name]@row = "Team 4", "(" + "T4" + ")") + IF([Team Name]@row = "Team 5", "(" + "T5" + ")") + IF([Team Name]@row = "Team 6", "(" + "T6" + ")") + IF([Team Name]@row = "Team 7", "(" + "T7" + ")")


Any help is appreciated!


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!