Hi Community,
I would like to use Confluence to create an evaluation matrix where criteria forms the lines of a table, each with a possible answer of "Yes", "No" or "NA" (Not applicable). Each criteria weights a certain % in the total score. Based on the answers provided, I would like the total score to be calculated.
I found some resources online referencing the HTML macro combined with the use of the Status or Task macros, but was wondering if there is an easier way to achieve this, out of the box or perhaps using a different macro.
Thank you!
Yes, it is possible to create an evaluation matrix with Confluence. Here's one way you can do this:
=IF(B2="Yes", A2, 0) + IF(C2="Yes", A2, 0) + IF(D2="Yes", A2, 0)
This formula will add the weight for each criteria if the answer is "Yes." Replace "B2", "C2", and "D2" with the cells containing the answers for each criteria. 9. Click "Insert" to add the calculation to the page. The total score will be displayed in the page.
You can also customize the appearance of the table and add more rows or columns as needed.
Thank you Deepak. Unfortunately the macros "Calculation" and "Column Sum" are not available in our instance, neither can I find them on the Confluence marketplace. Would you happen to know whether these are user macros created for your particular instance?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'm afraid that post was made by a 'bot that does not understand Confluence. Please ignore it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Laura Cristea and welcome to this community
Something what you want to develop (and a lot more) is certainly possible with our ConfiForms app
Formula fields, among 70+ other field types to choose from.
Quick examples
Alex
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.