Good morning,

I want to return specific values in a cell based on a drop-down list (single values per column), for example, if Activity = Marketing, then return value 45. However I need multiple options in each column, so I need the formula to then look for another activity and return a different value based on that.

Effectively, can I use multiple criteria with multiple results?

So the single formula works fine =IF(CONTAINS("Advertising", Activity@row), 45, "")

But I then want to look for Operations and return a value of 30.

Anyone any suggestions?




Best Answer

  • Kaveri Vipat
    Kaveri Vipat ✭✭✭✭✭✭
    Answer ✓

    Hi Lisa B 2022,

    You can try this formula for your condition-

    =IF(CONTAINS("Advertising", Activity@row), 45, IF(CONTAINS("Operations", Activity@row), 30, ""))


    Kaveri Vipat

    Senior Associate - Smartsheet Development, Ignatiuz Software

    2023 Core Product Certified

    Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!