I want to creat a “User Specific: If-Then-Else” Column but when I choose “Less than” or “Less or Equal” or “More than” or “More or Equal” I can only find “Number columns” while I have Many other columns wich has Numbers (Math Columns, Single Value Columns, If-then-Else Columns…)

like in this link https://ibb.co/rw42jPv

Thanks Community !

Looks like your user specific column is a text column. You need to change it to a number column.

No it’s an if-then-else Column with a Number output https://ibb.co/rw42jPv

But also when I try with Math columns its the same

1 Like

Ok, I understand now. I’ll have to check. I would think the math column would work for sure. I could potentially see the if then column not showing up and maybe requiring a math column to convert it, but if you are already having problems with the math column, then that may now work. I’ll get back to you.

1 Like

Not sure about marh column not being found here, but the If Then Else not being found can be because it isn’t read as a number. I faced this problem before and had to make a helper math column to convert it.

I have created Math Columns to convert to Number format but When I choose “Greather or Less than…” I can’t Find Math Columns until I make an output number in the Math Column for ex: simple calculation as " * 1"

Yes, it’s the way I made my workaround as well. It doesn’t convert to a number unless you do some math calculation with it.

1 Like