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!
