Recreate an "IF" excel formula
How would you recreate this formula within Smartsheet?
=IF(LEFT(T2,4)="Uber","Ride Share",IF(LEFT(T2,4)="Lyft","Ride Share","No"))
Context: I need to know if on this row in column [Chain] if it says "Uber", notate "Ride Share". If it says "Lyft", notate "Ride Share". If it has anything else, notate "No".
T2 would be my column [Chain] in the formula.
Darla Brown
What you meditate on, you empower!
Overachiever  Core Product Certified  Mobilizer  EAP
Best Answer

Just replace "T" with your column name and "2" with your row number or an @row reference if the formula is referencing cells on the same row.
=IF(LEFT(Chain2,4)="Uber","Ride Share",IF(LEFT(Chain2,4)="Lyft","Ride Share","No"))
=IF(LEFT(Chain@row,4)="Uber","Ride Share",IF(LEFT(Chain@row,4)="Lyft","Ride Share","No"))
You can also group like outputs by using an OR statement.
=IF(OR(LEFT(Chain@row, 4) = "Uber", LEFT(Chain@row, 4) = "Lyft"), "Ride Share", "No")
Answers

Just replace "T" with your column name and "2" with your row number or an @row reference if the formula is referencing cells on the same row.
=IF(LEFT(Chain2,4)="Uber","Ride Share",IF(LEFT(Chain2,4)="Lyft","Ride Share","No"))
=IF(LEFT(Chain@row,4)="Uber","Ride Share",IF(LEFT(Chain@row,4)="Lyft","Ride Share","No"))
You can also group like outputs by using an OR statement.
=IF(OR(LEFT(Chain@row, 4) = "Uber", LEFT(Chain@row, 4) = "Lyft"), "Ride Share", "No")

Thanks! Interesting that I originally tried just that (the 1st one) and it came back #Unparsable. I obviously left something out.
Darla Brown
What you meditate on, you empower!
Overachiever  Core Product Certified  Mobilizer  EAP

Help Article Resources
Categories
Check out the Formula Handbook template!