I have 2 scenarios where a custom formula would be beneficial:
I have a checkbox column and I want to know how many Yes/True that I have.
E.g. I am tracking a list of guests who have accepted an invite.
I would think the “count” summary would work, but it simply returns the total # of rows. Sum doesn’t work because booleans are not being treated as 1’s and 0’s.
I don’t want to filter my view to get the count of Trues. I just want to get it at the bottom while seeing the whole list.
I am using Coda as a CRM. I am tracking our deals. and assigning probabilities to each deal based on the stage of the discussion.
Deal name | Expected Contract $ | Probability of close
What I’d like is a custom formula for the summary: sum([Expected Contract $]*[Probability of close])
I could make another column that multiplies the two and then sum that. But I don’t want to see that column, because those values don’t really mean anything real.