Having trouble with a formula - inverse result!?

Hi All, I am trying to create a simple way for my committee to vote, by having a sub-item for each exec (Pres, VicePres, Treas, Sec, etc) where they indicate their Approve, Decline or Abstain a request. Then I use a formula sub-item column to output a 1 if the vote is to approve.
In the main item row I use another formula to sum the votes in sub-items and if >3 output ā€œApprovedā€ else ā€œNot Approvedā€. I want to use this to trigger an automation to send some notifications. With a committee of 7 I only need 4 votes from the voting exec to approve something.

Make sense? I guess there are better ways of doing this and I would like to hear it - probably not by adding marketplace apps - but the standard voting is not precise enough for my purposes.

I think the screen grabs will explain what i’m doing better.

The problem is that when I have 4 Approved votes it is returning ā€œNot Approvedā€, which seems strange… If I change the formula to ā€œ<3ā€ it shows Approved - why am I getting an inverse result here?

4 replies