[Help] Setting a value per dropdown label to create a scoring system

Platform discussions
, ,
1

Hi everyone,

I’m currently trying to create a score based ticket system within my board so that it creates a sum based on the item(s) that were selected in the dropdown.

For example:

  • SEO - 7 points
  • Revenue - 13 points
  • Security - 21 points

If these three labels were selected on the row (item) then it would add up and display a total score of 41. Where I’m struggling here is that I’m not sure how to associate a number to each dropdown label and then create a separate formula column to then dynamically pull through the sum based on what’s selected in the dropdown.

I’d assume this would be the best way to do this but as I’m still new to monday any feedback or recommendation on how to best tackle this would be appreciated!

Thanks in advance!

2

@lbowen.vashi,

You might try a formula like this:

IF(SEARCH("SEO",{Dropdown#Labels})>0,7,0) +
IF(SEARCH("Revenue",{Dropdown#Labels})>0,13,0) +
IF(SEARCH("Security",{Dropdown#Labels})>0,21,0)
2 Likes
3

Hi @JCorrell,

Exactly what I needed! Thank you so much!

4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.