I have an inspection app that uses a form to check different parts of a car.
Each inspection item is a different column, e.g. Brakes, windshield, tires, engine, etc. and user selects either “Yes” or “No” during the inspection.
I’m trying to create a virtual column that summarizes ONLY the “No” values in this row so a mechanic knows which items need to be addressed and ignores the “Yes” values.
For instance, if the windshield and tires are listed as “No” during an inspection:
The virtual column name would be “Alert! Check these items” where the desired output of the column would be “Windshield, Tires”.
I have 50 items as part of the inspection, so would need these to be a dynamic formula if possible.
I’ve tried the select and list functions, but keep getting errors. Any pointers in the right direction?