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	33	November 27, 2024
And/Or for If → Than → Else Column Feature Requests	12	709	August 18, 2023
If then glide column Ask for Help	3	269	February 2, 2021
Better and more consistent IF THEN logic Feature Requests	40	2772	October 18, 2023
If Then Else - Calculate on the "Then" Ask for Help	8	1220	January 12, 2025

If THIS and THAT THEN

Related topics