IF cell CONTAINS one/two/three different values, return corresponding values

Options
Sam Swain
Sam Swain ✭✭✭✭

Hello community,

I am attempting to return single or multiple values depending on a multiple dropdown column.

My dropdown column contains criteria "Consolidation", "Reduction", "Termination", "New"

Currently the formula works for single values with the following formula

=IF([Type of Project]@row = "Consolidation", "🝢", IF([Type of Project]@row = "Reduction", "︾", IF([Type of Project]@row = "New", "○", IF([Type of Project]@row = "Termination", "⨷"))))

I would like my formula to be able to return two/three/four of the values. For example if the "[Type of Project] cell had multiple criteria e.g. "Consolidation Reduction" I want my formula to return "🝢 ︾"

Many thanks in advance.

Tags:

Best Answer

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Sam Swain,

    You should be able to use this formula to accomplish this:

    =IF(HAS([Type of Project]@row, "Consolidation"), "🝢", "") + IF(HAS([Type of Project]@row, "Reduction"), "︾", "") + IF(HAS([Type of Project]@row, "New"), "○", "") + IF(HAS([Type of Project]@row, "Termination"), "⨷", "")

    Example output:

    Hope this helps - if there are any issues etc. then just post! ☺️

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!