Ben SmithBen Smith
Ben Smith/
Product Feature Rating
Product Feature Rating
Product Feature Rating

Product Feature Rating

For
Quinnie
From
Facebook
Status
Updating
Formulas
+
+
replaceAll
replaceAll
slice
slice
toNumber
toNumber
Share
Entries

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))
 
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!