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 stage shows “Scripting” and Jared is the assigned owner for that column in the table.
Hi John,
Can you just share a dummy doc? It will make it easier to create a formula for you.
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 individual rows for each of the column names.
P
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 your Video Data table into a “Header” and “Item” table. Each Assign column in the Video data table is a row in the new item table PS Stages. The PS Case Studies table is your new Video Data Header table. It has a filter as in the below:
With this approach, adding a new Stage, is simply a matter of adding it to the Stage Table and start using it. With the column based approach, you would need to go into the formula and manually change the formula. This doc is still small, as it grows and you need to refer to those columns more often, it very quickly becomes a maintenance nightmare.
I hope this helps.
Piet
