IF Statement formula

This discussion was created from comments split from: Multiple IF statements in a column formula.

Answers

  • Hawk23
    Hawk23 ✭✭

    Hi,

    Can you advise how to write an IF statement for a column that is "Business Type" with one of two options - "De novo" or "Base Biz". I am trying to write a formula to look at the "location@row" and if it is one of four locations, in the Business Type column it should say De novo; otherwise, Base Biz (for all others).

    Thank you!

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    @Hawk23 Try something along the lines of

    =IF(OR(Location@row = "A", Location@row = "B", Location@row = "C", Location@row = "D"), "De novo", "Base Biz")

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!