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

[image] Better and more consistent IF THEN logic Feature Requests I’ve spent the past few days trying to work out some IF/THEN logic for a side project. The problem is that this is something I could have worked out in a matter of a few minutes with actual code. I’m runni…

If THIS and THAT THEN

Ask for Help

Jeff_Hager August 24, 2022, 12:52pm 4

Topic		Replies	Views
And Or for IF Column Feature Requests	1	63	November 27, 2024
How to use logical operators in "If -> then -> else" column? Ask for Help	1	528	January 24, 2022
If then glide column Ask for Help	3	293	February 2, 2021
If-this-and-that-then Ask for Help	10	693	December 12, 2019
In the If/Then Column can you add a "AND" statement? Ask for Help	5	459	June 16, 2022

If THIS and THAT THEN

Related topics