Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula not working for pass fail remarks

Topic Labels: Formulas
84 1
Showing results for 
Search instead for 
Did you mean: 

Hello everyone,

I am trying to create a scoring system for our small team but one of the formulas I used is not working properly.

Here’s the formula I used:

and here’s the result:

I would be grateful if someone could help me with this. Thanks in advance!

1 Reply 1

Hey AJ,

Your formula states that if the monthly score is less than the passing score then it “PASSED”. The results are showing accurately. You should just need to switch the “<” to a “>” and it’ll work.

One quick note, if a PM has exactly 85% they would still technically fail. I’d suggest you do “>=” so 85% would be considered passing. Just something to bring awareness to either way.