IF formula when multiple options are selected


I'm trying to see whether or not there's a way to create an IF formula based on one of several options select in a multi-select pick list. One of the fields that my current IF formula is based on has a multi-select pick list. If users select multiple options within that pick list, the formula doesn't formulate.

The column highlighted in yellow above, is the multi-select column.

I just need for the formula work if "Yes, Approved" is one of any options selected in the pick list. Not if "Yes, Approved" is the only option (which is how it is currently working).

Is this possible? Any insights would be greatly appreciated.




Best Answer

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Answer ✓

    Hi @Lauren Ford ,

    Have you heard of the HAS function? It has the capability of counting selections in a multi-select dropdown.

    Your formula could look something like this:

    =IF(HAS([Approved for Food Grant (Yes/No)]@row,"Yes, Approved for Food Grant"),([Amount Allocated per Month]@row * [Number of Months Awarded (4 max)]@row))

    Hope this helps! Let me know if it works.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!