Ultimately, I am creating an audit app that randomizes questions. The critical data are part number (have a table for that), a list of questions categorized (a table for that. Question #, Category, and question as columns), and the main check sheet where the questions are answered (a table for that).
I have a table with column labels โRandom Communication 1โ and โRandom Communication 2โ and โRandom PPE 1โ and so on.
What I would like to do is create a formula that selects a question from a pool of questions pertaining to the subject of Communication, PPE, and others. Those questions are in a different table. All questions are answered Yes, No, N/A.
Is a way to accomplish this writing a formula for Display Name that selects a question from the pool? If so, what are some good resources to begin?
LinkedIn
Twitter
