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 |