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