I wonder what makes this condition false, when in fact they have the same value. Maybe it is because of their data type. Maybe the first one is a simple text and the other one is a different data type. So my question is , how will I know the data type of the values I’m trying to use?
Hi @Alyssa_Gono , difficult to answer without the context.
Often this is an issue of format, trying to compare an object to a text. Than can sometimes be solved adding .ToText() (or .ToNumber() or .ToDate()) in the both side of your comparison, to be sure to compare what’s possible to.
If you look at the screenshot above, you’ll see tiny icons next to each “thing” I used in my formula : Those icons represents the data type of those “thing” ()
So you can see that :
Table is a table
CurrentValue.[Column 2] is a number
[Column 3] is a list of numbers
(Date(s), Time(s), DateTime(s), Text, row(s)… and other data types also have their dedicated icons)
And if you have a doubt, you can always click on one of the “thing”/pill and the Editor will give you more info about that “thing” (which is what I did for CurrentValue.[Column 2] )
As for the data type of the result/output of the formula, it will also be represented by a small icon at the far right of the previewed result . If once again you have a doubt, you can hover the icon with your mouse and Coda will tell you what type it is .
As for knowing what could be wrong with your formula, I have to agree with the others : Without a sample doc or even just a screenshot, this is hard to tell