How do I generate scores in a column based on drop-down options selected in another column?

Meg Chhabria

Currently, I have the below dropdowns:

• PX resources ready
• CoE resources ready
• SOP ready
• NA

In another column, I want to pull in the following scores:

• If "PX resources ready" is selected = 1
• If "CoE resources ready" is selected = 1
• If "SOP ready" is selected = 1
• If "PX resources ready" and "CoE resources ready" are selected = 2
• If "PX resources ready" and "SOP ready" are selected = 2
• If "CoE resources ready" and "SOP ready" are selected = 2
• If "PX resources ready" and "CoE resources ready" and "SOP ready" are selected = 3
• If "NA" is selected = 0

How do I get this to work?

Amit Wadhwani

Hi @Meg Chhabria

Do you have a single multi-select dropdown column with the values OR the values are in different columns? This will help me recommend you a formula.

Meg Chhabria

Hi @Amit Wadhwani

I have a single multi-select dropdown column,

Thanks,

Meghana

Paul Newcome

Give this a try:

=IF(HAS([Dropdown Column name]@row, "N/A"), 0, COUNTM([Dropdown Column Name]@row))

Meg Chhabria

Hi @Paul Newcome,

Thank so much! This works however, when "NA" is selected, I want it to result in a score of "0". Is there an exception we can add to the formula to incorporate this?

Meg

Paul Newcome

That's what is is set up do, but it looks like I used "N/A" instead of what you have "NA". Try taking that forward slash out of there.

Meg Chhabria

@Paul Newcome You are a genius - it worked! Thank you so so much :) :)

Paul Newcome

Happy to help. 👍️