I am seeking to recreate an old spreadsheet in a more useful manner on Coda.
I want to make the phases in grey as their own table so additional information can be stored for each phase.
If the document had only a single phase value, this would be simpler (I could put the Draft, Finalize, Update as the column header and list the appropriate phase as a drop down) but its status can carry across multiple phases so using a dropdown of phase names in a single column doesn’t feel appropriate.
Ideally I could state that this row contains all cases where a row in the other table has a value matching the column name displayed… something like: [RACI Table].Filter([thisRow.Name.ToText()].Contains(F))
Probably need a redesign of the tables and any help is appreciated.