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!
