"Show if" Multiple USERSETTINGS Criteria

I’m trying to use multiple criteria for a “Show if” and it is not working.

I’m trying to check both of these items:

ISNOTBLANK(USERSETTINGS(Option1)

USERSETTINGS(Option2) = “text”

I tried:
AND(ISNOTBLANK(USERSETTINGS(Option1)), USERSETTINGS(Option2)=“text”)

but that did not work. It gives me an error code
“Function ‘USERSETTINGS’ should have exactly 1 parameters, the name of an option from the user settings”

Thanks any help is appreciated

0 3 174
3 REPLIES 3

Try putting quotes around Option1 and Option2

Try this

AND(ISNOTBLANK(INDEX(_Per User Settings[Option 1],1)), INDEX(_Per User Settings[Option 2],1)=“TEXT”)

Worked perfectly!!!

Thank you

Top Labels in this Space