When using a lookup on a table that is using Cross-doc I result with the little red top right corner stating “not a valid row reference.” It does still lookup allowing me to insert related column from said lookup table but I don’t get the blue box surrounding that acts as a hover over. Please comment if said question needs to be more specificity.
Hi @Brantley_Thornton,
this happens when the Lookup is not providing the correct data type expected by the column (independently from Cross-doc or not).
Let’s assume you have a Table with a Lookup referencing TableA
Sometimes the lookup formula (through Lookup()
or Filter()
) is retrieving a reference that is either:
- “Too wide”
[TableA].Filter([ColumnA].isNotBlank())
It’s actually aList()
, not aTableA
reference
or - “Too narrow”
[TableA].Filter([ColumnA].isNotBlank()).First().[ColumnA]
It’s a sub property property of the reference
I don’t know if this is your case, but it’s a good way to assess a first check.
Let me know if otherwise.
Thank you.
1 Like