Hello! I’m still learning to use Grist, so maybe this is a pretty obvious question, but after searching for a while I didn’t found anything that answered my question. Here’s what I want to do:
I have one table assigning possible projects I’m thinking about doing. Currently it looks something like “Subject/ Details / Channel (a choice column with “text, video, audio” as choices) / Date added / greenlight”. The “greenlight” is a toggle column is when I decide to move forward with it and start scripting/planning. I want a second table to lookup the ‘greenlight’ column and only pick the ones that that are on, auto fill the subject and details column, add the current date (the day the button is toggled) and two more columns that I’m gonna fill manually (like “Estimated by” and “Stage”). How can I do this? Do I need a reference column using the ‘greenlight’ or ‘Subject’? Or something else entirely?
Thanks in advance!