Product Feature Rating

Caveats

Single digit values must have a leading 0 so every number is the same length. This allows for slice() to be more easily used for the calculation.
Option text must contain no other numbers.
The final Rating formulas allow for 5 options to be selected for each multi-select, but this can be increased if need be.

Complexity Value

replaceAll(prop("Complexity"), "[^0-9]", "")

Success Criteria Value

replaceAll(prop("Success Criteria"), "[^0-9]", "")

Rating

toNumber(slice(prop("Success Criteria Value"), 0, 2)) + toNumber(slice(prop("Success Criteria Value"), 2, 4)) + toNumber(slice(prop("Success Criteria Value"), 4, 6)) + toNumber(slice(prop("Success Criteria Value"), 6, 8)) + toNumber(slice(prop("Success Criteria Value"), 8, 10)) - toNumber(slice(prop("Complexity Value"), 0, 2)) - toNumber(slice(prop("Complexity Value"), 2, 4)) - toNumber(slice(prop("Complexity Value"), 4, 6)) - toNumber(slice(prop("Complexity Value"), 6, 8)) - toNumber(slice(prop("Complexity Value"), 8, 10))

Rating (Combined)

toNumber(slice(replaceAll(prop("Success Criteria"), "[^0-9]", ""), 0, 2)) + toNumber(slice(replaceAll(prop("Success Criteria"), "[^0-9]", ""), 2, 4)) + toNumber(slice(replaceAll(prop("Success Criteria"), "[^0-9]", ""), 4, 6)) + toNumber(slice(replaceAll(prop("Success Criteria"), "[^0-9]", ""), 6, 8)) + toNumber(slice(replaceAll(prop("Success Criteria"), "[^0-9]", ""), 8, 10)) - toNumber(slice(replaceAll(prop("Complexity"), "[^0-9]", ""), 0, 2)) - toNumber(slice(prop("Complexity Value"), 2, 4)) - toNumber(slice(replaceAll(prop("Complexity"), "[^0-9]", ""), 4, 6)) - toNumber(slice(replaceAll(prop("Complexity"), "[^0-9]", ""), 6, 8)) - toNumber(slice(replaceAll(prop("Complexity"), "[^0-9]", ""), 8, 10))

<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" width="40px" /> By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!

</aside>