I want a column that goes like this: If SUBSCRIPTION STARTED is TRUE ‘AND’ SUBSCRIPTION ENDED is FALSE then 1, else 0. I don’t seem to get that working in the In This Then Else column. Is this not how ‘add case’ works, or do I do something wrong?

An IF column does not use AND logic. It’s basically always OR logic. I would structure it like this: IF Started is false THEN 0 IF Ended is true THEN 0 ELSE 1

If THIS and THAT THEN

Ask for Help

Jeff_Hager August 24, 2022, 12:52pm 4

2 Likes

Topic		Replies	Views
How to use logical operators in "If -> then -> else" column? Ask for Help	2	496	January 24, 2022
If-this-and-that-then Ask for Help	10	672	December 12, 2019
If then glide column Ask for Help	3	283	February 2, 2021
IF THEN ELSE with AND CASE Ask for Help	3	1742	July 4, 2020
In the If/Then Column can you add a "AND" statement? Ask for Help	6	412	June 17, 2022

If THIS and THAT THEN

Related topics