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?

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