II GUYS, HOW CAN I ADD A REQUIRED IF WITH MORE THAN ONE OPTION? i WANT AN OPTION TO APPEAR FOR ONLY 3 SPECIFIC ANSWERS
AND([ColumnA]=โAnswerAโ,[ColumnB]=โAnswerBโ,[ColumnC]=โAnswerCโ)
๐
@Aleksi_Alkio wrote:AND([ColumnA]=โAnswerAโ,[ColumnB]=โAnswerBโ,[ColumnC]=โAnswerCโ)
This is correct if the answers that will require are on separate columns.
But if not, it should be
OR([
ANSWER]="OPTION 1",
[ANSWER]="OPTION 1",
[ANSWER]="OPTION 1"
)
Or better yet
IN([ANSWER], List("OPTION 1", "OPTION 2", "OPTION 3"))
User | Count |
---|---|
43 | |
29 | |
24 | |
22 | |
13 |