Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am so frustrated and hoping someone can help me quickly as I have to complete this by tomorrow.
I have a spreadsheet with 3 tabs: Users, Groups and XWalk
Users contains a name and a facility that person is associated with.
Groups contains a name and the groups the person is currently associated with.
The Xwalk shows a mapping of facility to group names.
The goal is to identify is a user is in all the applicable groups for the facilities they belong in. For example, KEY_NAME: Cnocjv, Vyumldt is in 4 facilities but only 1 group. I need a table that shows whether a user is "Already in group" or "Need to Add".
For the life of me I can not get this to work. Someone, please help me.
I was hoping it would be as simple as something like if(Facility=Current_CAG,'Already in Group','Need to Add')
Can you post some sample data for all the three sheets?
There is data in the QVW and I referenced an example.
It seems that you have short forms in Current_CAG....
So, MSJMC = Mercy San Juan Medical Center I assume, but since the values don't match... how will you get Already in the group?
Also, on the Second tab of the Excel file... (Cell B2), you left Lisa's full name in there... you might want to fix the Excel file and repost it
Lol... then use this
if([Consult Accelarator Group]=Current_CAG,'Already in Group','Need to Add')
I tried that but it didn't work for other people. For example,
Ok, here's something strange... For Lisa A., if I don't filter on a Currect_CAG, I see Need to Add
No filter:
but if I click on the Currect_CAG = CHMC, it shows Already in Group.