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
And Or for IF Column Feature Requests	1	22	November 27, 2024
And/Or for If → Than → Else Column Feature Requests	12	655	August 18, 2023
If then glide column Ask for Help	3	260	February 2, 2021
Better and more consistent IF THEN logic Feature Requests	40	2745	October 18, 2023
If-this-and-that-then Ask for Help	10	659	December 12, 2019

If THIS and THAT THEN

Related topics