# 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