Context: I’m trying to create a list of what columns are not checked and list them by specific tags in the same cell. This will be important as there are not only thousands of rows (So separate tables to keep track of the individual rows is out of the question), but I will also be pulling the list to send templated emails requesting the missing information for each row based on what is in the “What’s Missing” column).
Is it possible given the constraints to list all the “False” check boxes with custom labels.
“What’s Missing” Is the Table I’d like to calculate the field in.
“DB What’s Missing Ref” is a reference for what the formula should output in various situations.
“DB Amendment Requirement” is a database of the labels id like to use (they reference templates for the aforementioned emails )
If It helps, the Emails are structured:
Missing Info 1
Missing info 2