[Screenshot 2026-02-07 at 12.22.32 PM] I need a fomula to go in the stage owner column which looks at the stage column and looks for the column in the table with the same beginning of the name and insert the employee who is assigned. For example the first row should return “Jared” because the sta…

Hi John, Can you just share a dummy doc? It will make it easier to create a formula for you. [image] Guide: How to share your doc with the Coda Community Tips and Hacks TL;DR Guide (especially for new Coda-Users): How to share your doc with the Coda Communi…

Hi John, Welcome to the community! You need to enable sharing of your document. Short answer to your question: setting up a table in this way is the best easy to do it in a spreadsheet. In coda that set up very quickly runs into problems, as you have seen. It is much more flexible to create indi…

Can you give me an example of how that would work. I dont understand.

Hi John, I have built a quick demo to show the concept in the doc on the page Example. Using the Assign type columns in your Video Data table can be made to work, but you would need to hard code each column into the formula to determine the entry to put in the ASSIGNED TO column. I have split you…

Need a field formula to look up based on column title

Cristian_Nichifor February 7, 2026, 8:44pm 2

Hi John,

Can you just share a dummy doc? It will make it easier to create a formula for you.

Topic		Replies	Views
How to Link Column names to row names	2	377	January 3, 2024
Objects in Column Titles / Formulaic Access to Column Titles Product Feedback	1	596	February 5, 2020
Button to add rows with multiple columns from another table	2	150	August 19, 2024
Control the formula in the coda column	11	612	May 5, 2022
How to get column name? (To generate )	10	5066	August 29, 2023

Need a field formula to look up based on column title

Related topics