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?