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

1

I was playing around with formulas to try to detect them in their cells when I got this weird result:

image
image.png1156×544 22.6 KB

You can see that if I evaluate whether a row is blank and then try to put a number (I tested with many numbers) the cell returns a reference to itself.

Here’s what happens if I add rows:

image
image.png1002×760 13.9 KB

And then if I force reload:

image
image.png970×746 10.2 KB

Why does this happen? I expected it to return “5” because (excluding itself) the row was blank.

Interestingly, by viewing details we can then get this bug by continuously hovering over the #r1 reference (is that what we call them?)

image
image.png1294×1396 71.4 KB

I don’t know if this is related to the above problem or not

1 Like
2

Hi @cnr
I believe it has something to do with the type of your column. It seems to be a link type, not a number. If you would like the formula to show a number then the column should be of number type.

3

@cnr, I’ve seen this before too when I’ve referenced/looked up columns with a blank display value. That’s a fun bug though!

4

@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