There are Question and Answer tables
Problem:
When selecting Product with values 3 and 4, the fields disappear.
Formula in Valid_if in columns:
Answer 1: SELECT(Question[Question 1], [ID]=[_THISROW].[Product])
Answer 2: SELECT(Question[Question 2], [ID]=[_THISROW].[Product])
Answer 3: SELECT(Question[Question 3], [ID]=[_THISROW].[Product])
Request:
How to make columns (Text format) appear when selecting the value 3,4 of the Products column
Have I installed the wrong formula? Get help from the experts
Result when choosing value 1,2,3,4:
Desire
