Is there any way to set the Scale columns to a custom weighting? I am not familiar with using formulas to accomplish this but I would like to have the ability to quickly set the scale using icons and then have the weighting calculated in a SCORING column.
I know that this could be achieved with a number column but I like the idea of users being able to scan the the Scale columns visually.
Here is an example coda of what I’m wanting to achieve with the values added and entered manually by me:
Thanks in advance!