I would like to add the given criteria to the scorecard using this number field value.

Hi @testpinaack ,

Not entirely sure that is possible with a weighted score, especially since these types of formulas can only have a field entered once as an a positive/negative input, and doesn't have the option to account for IF/THEN clauses like you shared.

I also think you may run into problems with this since weight scores are normalized. What is normalization?

Normalization is an operation that takes all field values across all ideas in a project.

• 0 is taken as the minimal value. Alternatively, we take the lowest number if you are using negative numbers.

• 100 is the highest field value.

• All values are then plotted based on their relative value between the lowest and 100.

^ So as mentioned, this is factored among all ideas. Whatever the highest number-field is will be 100, while the lowest will be 0. The range will essentially be disregarded in some cases.

Instead you might find value in formatting the number field to the criteria you mentioned. Might look something like this: