I would appreciate your helping hand for a use case that can be used in many applications.
Q-1: - Formula syntax:
I am looking to create from a multiple choice matrix (Table 4) a table that creates a column listing the checked columns of Table 4, like in Table 5 ( in this sample I manually entered the data)
Q-2: - Formula syntax:
The next step is to easy identify missing details in Table 5.
When Detail (x) is true AND Create (x) ( x from Detail should be the same as from Create) meaning that there are no missing details.
In the sample above (manually added) you can see that for Detail2 should be available, but Created2 is false and therefore identified as missing detail.
It was a rather big challenge to express my question, please feel free if something is unclear or you know a post where I can find a solution.
Thanks in advance for your time.