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