I'm probably getting tripped up on syntax for find row:
=FINDROW($[SYS_USER_GROUPS], "$[SYS_USER_GROUPS][Name] = %", "HC-VendorSetupTeam")>0
Returns true or false if "HC-VendorSetupTeam is found" if it is a user is in that group.
I need to check if a user is in one or more groups. I looked around the docs and then tried to combine it with FILTER() to get the results but I'm just not finding it.
How can this done?
Happy to help! For this, you can use the AND() operator to check if the user is in different groups. The formula would look something like:
AND((FILTER($[SYS_USER_GROUPS], "$[SYS_USER_GROUPS][Name] = %", "Group A")>0),(FILTER($[SYS_USER_GROUPS], "$[SYS_USER_GROUPS][Name] = %", "Group B")>0))
The formula will return true if both arguments are true (user is in both groups).
Thanks @Alyssa I'm not used to the syntax yet, I switched it to OR and got exactly what I needed!
You're welcome, I'm happy that helped!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.