Hi, I’m not sure why I’m having an issue with this. I use a similar same set up/formula on another column and it doesn’t show me the “this is not a valid row reference error”. So, it somehow works here [image] but not here (unless I change the column type to a “text” versus the current “look up”…

Dear @anon36717443 , This post will explain you in detail the symbols of the formula chips [image] Introducing formula chips News from Coda Hello Everyone, Today we are launching another exciting improvement to make reading and writing formulas in Coda a little bit easi…

Dear @Jean_Pierre_Traets , thanks for the reference - this will be helpful! I’m still unable to understand why the formula went wrong though. The formula chip shows that my Project Type reference is of another format. But it follows the same “structure” as the company type. Essentially, when you…

Hi @anon36717443 :blush: ! The “problem” might not come from your [Project Type] lookup field but from your Projects field. Your Projects field is the one outputting a list of rows from your Projects table (I guess :innocent:) in the first place (as this what the visual cue for thisRow.Projects is…

Hi @Pch Thank you for this! Changing the project options setting to disallow multiple settings worked! I’m still not quite sure of the logic but I’m super glad it worked nonetheless :smiley:

No problem @anon36717443 :grin: ! Glad to know it helped :grin: !

"This is not a valid row reference"

Jean_Pierre_Traets February 28, 2023, 8:28pm 2

Dear @anon36717443 ,

This post will explain you in detail the symbols of the formula chips

Topic		Replies	Views
"not valid row references"	2	648	November 24, 2022
The never ending saga of look-up vs select lists, and more potential differences	9	2687	December 12, 2019
Lookups, different results, different input methods?	21	3005	September 26, 2021
Why is this "not a valid row reference"?	9	3789	October 14, 2020
I have "is not a valid row reference" but seek the beautiful blue lookup hover over	1	1112	November 19, 2020

"This is not a valid row reference"

Related topics