Worksheet Function to retrieve usergroups of certain user

[appleglaze28]

I'm currently doing a excel sheet, where admin through TM1 web can reassign users either by adding the user a new group or transferring a user from an old group to a new group?

I was thinking of creating a drop down list to enable admin to choose a specific user's current groups if he wish to remove that user from those current group he belongs to, to a new user group.

Thanks in advance for the help.

[lotsaram]

I'm currently doing a excel sheet, where admin through TM1 web can reassign users either by adding the user a new group or transferring a user from an old group to a new group?

I was thinking of creating a drop down list to enable admin to choose a specific user's current groups if he wish to remove that user from those current group he belongs to, to a new user group.

Thanks in advance for the help.

A zero suppressed active form of }ClientGroups with groups on rows and the client selected as the title element would do the trick for current group assignments (and to remove user from group just enter spacebar in the value field ...)