#ri-num and #r1 showing up as result to IfBlank(thisRow) evaluation. Why?

@tomavatars Even if you set the column type to text, after entering in the IfBlank() formula it converts the column to a link . If you click on the link icon it just says it’s linked to the current table you are in which doesn’t really make sense.

I’m not sure if this is related, but when you reference thisRow you are actually referencing a few things including the tableID, rowID, and displayValue. I think by using IfBlank() you’re asking if this entire tuple is empty (this is according to @nigel in this thread). Since the tuple is not blank, it returns the first parameter in the formula which I suppose is just the #r1 or #r2 reference to the cell itself.

Instead of referencing thisRow I tried =IfBlank([Column 1], 5) so you are forcing the circular reference to the column itself and it returns the circular error (which is the correct error). Perhaps this is the error that should show up if you use thisRow too:

54%20PM