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.
- 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!