Hello all,
I have an If → Then → Else column in Glide that categorizes QS rankings.
Source value examples:
58
130
416
Logic:
If value ≤ 10 → Top 10
If value ≤ 50 → Top 50
If value ≤ 100 → Top 100
If value ≤ 150 → Top 150
If value ≤ 200 → Top 200
If value ≤ 300 → Top 300
If value ≤ 500 → Top 500
If value > 500 → 500+
The issue:
58 returns Top 10 instead of Top 100.
416 returns Top 10 instead of Top 500.
130 returns Top 150 correctly.
I also created a Math helper column to force the value as a number, but the issue still happens.
Is this a caching bug, column type issue, or If → Then → Else issue? What is the best workaround?
Interesting. I would assume it’s comparing as text, but I’m not quite understanding the pattern.
Can you try recreating the IF column from scratch?
Hi,
Invert the if, the largest numbers at the beginning and the 10 last, or use only the smallest Example: If QS World < 11 then Top 10
I did, and noticed that it always reads the first logic and applies it to the rest whether it is true. I think it is a glitch? How to report it to Glide team if it is?
I did, and still the same. I also inverted IF THEN ELSE and it turned out to keep reading the first logic no matter what.
Can you trace up through the QS World column? Is there anywhere in the path upwards where it may not return a numeric value or may be a number in a text column? Normally you wouldn’t even be presented with mathematical operators it it’s text, but I think I’m missing a piece of the puzzle.
Otherwise you can use the chat bubble in the bottom right of the builder to escalate to support, but I’m not convinced that it’s a bug yet. Otherwise there would be a lot of people complaining about broken IF logic.
What the reason for the “If | QS World” column? Could you configure the “QS Test” column by referring to “Ranking | QS World (General)” lookup column directly?
What is the type of the column “Ranking | QS World (General)” is looking up? Is it a math or number column?
The “General” value comes from another numerical table. In other words, the source columns are all numeric.
What makes this unusual is that I am using almost 10 similar tables, and around 7 of them work perfectly with the same logic. Other ranking categories also work correctly, and they look up their values from the same ranking table as numeric values.
The issue only appears in the specific columns/screenshots I shared. That is why I suspected it might not be a formula logic issue, because the same structure works elsewhere with the same type of numeric lookup source.
I created the “If | QS World” column only as a workaround/test layer to normalize the looked-up numeric value before applying the category logic, but the source itself is already numerical. Check the screenshot, there is where I get the Ranking | QS Word General.
Check this out. Shanghai Final column I believes it reads a hidden number which is why it returns with 500 + because Shanghai Final column is empty. I cleaned it up multiple times and didn’t work.
This is the source where General column gets the ranking from, all of them are numeric.
Could you double-click on the header of “If | Shanghai” and show a screenshot of how that if-then-else column is configured?
