Function

I need to do a calculation in the glide table as follows:

Column A contains : subscribed / unsubscribed

Column B contains : new / old

I need to know how many old subscribers. and how many new subscribers.

What is the formula to know this?

You could do that as follows:

  • Create an if-then-else column
    – If Column A is not subscribed, then empty
    – If Column B is new, then true
    – Else false
  • To get a count of new subscribers, create a rollup column that counts the number of true values in the if-then-else column
  • To get a count of old subscribers, create a rollup column that counts the number of false values in the if-then-else column

The above takes advantage of the fact that a Glide boolean can have 3 states: empty, true, false

  • Not subscribed: empty
  • Subscribed and new: true
  • Subscribed and old: false

Update: I just tested that quickly and it doesn’t work. There seems to have been a change in behaviour where an empty boolean value is being treated as false. Therefore, a 4th column is needed.

  • 1st if-then-else:
    – If Column A is not subscribed, then empty
    – If Column B is new, then true
  • 2nd if-then-else
    – If Column A is not subscribed, then empty
    – If Column B is old, then true
  • 1st Rollup
    – Count true values of 1st if-then-else
  • 2nd Rollup
    – Count true values of 2nd if-then-else

3 Likes

Thank you very much, I benefited from this
Thank you again