# "not valid row references"

**URL:** <https://connect.superhuman.com/t/not-valid-row-references/35636>\
**Category:** Ask the Community\
**Created:** [November 23, 2022, 7:07pm UTC](https://connect.superhuman.com/t/not-valid-row-references/35636 "2022-11-23T19:07:24Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Filipa\_Didier](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/filipa_didier/32/30384_2.png) [@Filipa\_Didier](https://connect.superhuman.com/u/Filipa_Didier)\
**Post date:** [November 23, 2022, 7:07pm UTC](https://connect.superhuman.com/t/not-valid-row-references/35636/1 "2022-11-23T19:07:24Z")

</div>

Hi!  
I’m getting the result that I want but get the “not valid row references” error… what’s wrong with my formula?  
Thanks!!

 ![invalidrowref](https://global.discourse-cdn.com/coda1/original/3X/7/6/7665fe831af42d2580aa252fa4fb19a23318d071.jpeg)

---

<div class="post-metadata">

**Author:** ![Scott\_Collier-Weir](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/scott_collier-weir/32/29677_2.png) [@Scott\_Collier-Weir](https://connect.superhuman.com/u/Scott_Collier-Weir)\
**Post date:** [November 24, 2022, 1:36am UTC](https://connect.superhuman.com/t/not-valid-row-references/35636/2 "2022-11-24T01:36:15Z")

</div>

Hey there! That’s because your column type is a lookup.

Lookup column types contain row-reference values.

Your filter formula returns row references, but at the end of your filter formula you chained on a green “ready to activate” chip which turns what would have been a list of row references into a list of text references

So if you want text references, just change your column type to text

If you want row references, delete the green “ready to activate” chip

---

<div class="post-metadata">

**Author:** ![Filipa\_Didier](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/filipa_didier/32/30384_2.png) [@Filipa\_Didier](https://connect.superhuman.com/u/Filipa_Didier)\
**Post date:** [November 24, 2022, 5:15pm UTC](https://connect.superhuman.com/t/not-valid-row-references/35636/3 "2022-11-24T17:15:29Z")

</div>

Thank you, Scott! I’m just starting with Coda, you helped me understand it better!!

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [November 27, 2022, 5:16pm UTC](https://connect.superhuman.com/t/not-valid-row-references/35636/4 "2022-11-27T17:16:12Z")

</div>

Closed on November 27, 2022, 5:16pm UTC

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
