I’m analyzing responses to a pretty long questionnaire in Coda. I’m putting questions in columns, responses in rows. There are few things I wanna figure out if it is possible to do before i go deep.
I want to have metadata about the questions. If the questions were rows, I’d just add a column to provide additional data about those questions, perhaps with a select list linking to another table. But since the questions are columns, I don’t know if this is possible. For instance, I want to categorize the questions, and I also want to provide a short-form version of the question for quick reference along with the full question asked in the row. But if I just add rows at the top providing these additional descriptors then they’ll be treated as answers.
I’m guess it’s not possible to have column headings themselves be look ups to another table, which would solve the problem.
Any help would be great!