Need help with multiple If formula
Hello - I am having trouble converting an excel Ifs formula into smartsheet. I am able to get a single If formula to work, but cannot link them to each other - or even know if it is possible. Full disclosure, I am not very familiar with more advanced formulas.
I have a column that has multiple entries. I created another column to rename the entries for sorting purposes (as an aside, I couldn't just rename the original column because it is linked to many other sheets/dashboards).
If the cell is named Pre-Qualify, I want it to be 00.Pre-Qualify in the new column; if it's named Cover the Bases, then it should be 01. Cover the Bases, etc. Below is what I've used on a single cell and it works. How do I link them together for one large formula? I've tried to use AND or OR and other several things and it either comes out Unparseable or Incorrect Argument. I've added the Logical Expression 2 as "blank" and it will again work on the singular formula, but not if I try to link them.
Example using IF/OR:
=IF(OR(Stage@row = "Cover the Bases", "01.Cover the Bases", IF(OR(Stage@row = "Pre-Qualify", "00.Pre-Qualify"))))
Single formulas that work are below.
=IF(Stage@row = "Pre-Qualify”, "00.Pre-Qualify")
=IF(Stage@row = "Cover the Bases”, "01.Cover the Bases")
=IF(Stage@row = "Pipeline", "02.Pipeline")
=IF(Stage@row = "Pending”, "03.Pending")
Any help is appreciated. Thank you!
Best Answer
-
A nested IF seems like something that would work for this...
=IF(Stage@row = "Pre-Qualify”, "00.Pre-Qualify", IF(Stage@row = "Cover the Bases”, "01.Cover the Bases", IF(Stage@row = "Pipeline", "02.Pipeline", IF(Stage@row = "Pending”, "03.Pending"))))
The basic format is if(logical_expression, value_if_true, value_if_false). Basically, you would be asking if the first item is true. If it's false, fall to the next. This will work for what you are asking.
Answers
-
A nested IF seems like something that would work for this...
=IF(Stage@row = "Pre-Qualify”, "00.Pre-Qualify", IF(Stage@row = "Cover the Bases”, "01.Cover the Bases", IF(Stage@row = "Pipeline", "02.Pipeline", IF(Stage@row = "Pending”, "03.Pending"))))
The basic format is if(logical_expression, value_if_true, value_if_false). Basically, you would be asking if the first item is true. If it's false, fall to the next. This will work for what you are asking.
-
Thank you! I swear I was trying that, but it wasn't working :) Thanks so much - I appreciate it!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!