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
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
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |