Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 14, 2024 01:49 PM
Hi,
We have a scoring system that rates functionality in an interface. So as not to bias the total score, if the functionality isn't present we ask evaluators to give it a -1.
In Excel, the final score is determined by a formula that:
I'm able to use sum to get the total score but I'm not sure how to get the number of criteria scored without using countif which Airtable doesn't seem to have.
Is there a way in AT to do what I'm trying to do? Any help is most welcomed.
Solved! Go to Solution.
Mar 15, 2024 09:30 AM
Ah! Sorry, try this:
IF(
{Score 1} > 0, 3
) +
IF(
{Score 2} > 0, 3
) +
IF(
{Score 3} > 0, 3
)
Mar 14, 2024 08:20 PM
Hmm, what if you did a formula with a bunch of IFs in it?
IF(
{Score 1}, 3
) +
IF(
{Score 2}, 3
) +
IF(
{Score 3}, 3
)
If your data's set up differently could you provide a screenshot with some example data?
Mar 15, 2024 07:50 AM
Hum...it's a good start and not working exactly the way I need.
Formula in the Max Possible Score: VTG field is:
But it's not coming up with the right answer. Based on the values in fields 5.1, 5.2, and 5.3 (image), the Max Possible Score: VTG field should be 6 not 9, because we're not counting the criterion that got scored -1 because the functionality isn't present.
I also need to look at my score formula (Score: Voice, Tone, ...) but that's on me.
Any additional thoughts are most welcome. Thank you 😁
Mar 15, 2024 09:30 AM
Ah! Sorry, try this:
IF(
{Score 1} > 0, 3
) +
IF(
{Score 2} > 0, 3
) +
IF(
{Score 3} > 0, 3
)
Mar 15, 2024 11:37 AM
Thank you, Adam! That works exactly the way I wanted it to. 💝