Creating a score based on checkbox and radio button selections

Question

Hi everybody

Hoping for some assistance please with calculating scores based on selections in a JSM form to create a prioritisation score.

I tried this solution without luck.

In another example, we ask who/what is impacted (user can select multiple via checkbox) and we assign points per selection like:
Customer | 2
Revenue | 2
Efficiency | 1
Regulation | 3

I've spent every working minute in the last 2 days attempting the automation for this, creating endless test tickets and smashing AI with no luck.  I am familiar with jira automation but not formulas or variables.

Ideally I wanted to not have to create actual jira fields and have the score populate from the form entry, but if I need the jira fields to make it work then that's fine (and how I've currently set it up).

Hoping for any guidance, please.

Many thanks, Brendan

Kavitha Vaikunthavasan _Seibert-Products_ · Answer

Hi Brendan,

Great use case, this is exactly the kind of weighted prioritisation scoring that comes up a lot in JSM. The automation approaches mentioned above will work, but if you'd like to avoid maintaining automation rules altogether, there's another option worth considering.

Awesome Custom Fields has an advanced Formula field, where you can easily create a formula for Jira or JSM. Here's how you could set this up:

For the urgency score (radio button / single select):

Create a standard Jira select field for Urgency (Critical, Urgent, High, Medium, Low) and add it to your JSM portal form. Then create an ACF Formula field that maps each option to its numeric value, the score calculates automatically as soon as the field is filled in, no automation trigger required.

For the impact score (multi-select / checkbox):

This is also possible with the ACF Formula field, since it uses Jira expressions - allowing you to handle conditions like (IF impact contains X, add N) directly in the formula. No automation rules needed.

I am from the ACF team - happy to support you in setting this up. Feel free to schedule a call, and you can use the free trial to test whether it fulfils your needs.

Arkadiusz Wroblewski · Answer

Hello @Brendan Sheppard

Yep  I checked the current Atlassian docs, and what you’re trying to do is 100% doable in JSM with Automation. The reason it usually “doesn’t work” is one of these two things:

If you’re using JSM Forms fields that are not mapped to Jira fields, you must trigger the rule with Form submitted. If you use “Issue created” or “Field changed”, those form-field smart values often won’t resolve correctly.

And for the scoring itself, the right approach is exactly what you were aiming for: use an automation variable and add points with the built-in math functions (like plus()), then write the result into a Number field (because you need somewhere to store/display the score).

Also important: for your checkbox question (multi-select), you generally can’t treat it like a single value. Use contains logic (because it’s a list), and do separate IF blocks so multiple selections can add up.

So the working setup is:

Trigger: Form submitted

Variable: score = 0

IF urgency = X → score = score + N

IF impact contains Y → score = score + N (repeat for each option)

Finally: set your Prioritisation score number field to {{score}}

Wish you a great Day 🤠