II GUYS, HOW CAN I ADD A REQUIRED IF WITH MOR...

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

0 3 296
3 REPLIES 3

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"))

Top Labels in this Space