Multiple IF Formulas - cannot figure out why it's producing a "0"
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
-
change your formula syntax to the below. Should fix it.
=IF([Team Name]@row = "Team 1", "(T1)","")
Answers
-
change your formula syntax to the below. Should fix it.
=IF([Team Name]@row = "Team 1", "(T1)","")
-
@Leibel Shuchat - thank you!!! I swear I thought I tried that, but I had not. Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!