Hi, I have a base that covers a script breakdown. One table within the base includes all information in regards to a Scene within an Episode, including all characters that need to be recorded within that scene (Script Breakdown).
Another table is a more granular version of this that breaks out each character of that scene to it’s own row. Both tables are linked via the Episode and Scene number. In this table I have a check box that I tick if a particular character voice has been recorded (Script Recorded Breakdown).
What I would like to do is create a formula within the Script Breakdown table that says something along the lines of ‘if all of the checkboxes within the “Script Recorded Breakdown Table” that link to this particular scene are checked’ than give the answer ‘recorded’ otherwise leave blank or something along those lines.
I hope this makes sense? In excel I would use a combination of if/vlookup but I’m not too sure what to do in airtable. Any ideas??