I have this formula and it works great except I need to to filter for the year 2022
If(IsEmpty(ComboBox2.Selected.Title),
Blank(),
LookUp(ChairSurvey_1, 'Meeting Group'= ComboBox2.Selected.MeetingName , ChairPerson.DisplayName )
)
I tried to add && 'Service Year'=2022 but that didnt work and I am not sure how to get this to work.
Solved! Go to Solution.
No, it has last years name in it that is why I need to filter it to this years name
I did it a different way and it is working now.
I changed the lookup list it was easier
If(IsEmpty(ComboBox2.Selected.Title),
Blank(),
LookUp(SafetyMeetingGroups_1, MeetingName = ComboBox2.Selected.MeetingName, Chairperson.DisplayName)
)
User | Count |
---|---|
256 | |
111 | |
95 | |
48 | |
40 |