Apr 26 2021 08:38 AM
Hi All
Any ideas why this is not working please?
If I do a TEXTJOIN for just VACANT rooms it works fine, but if I add in the AND function for both VACANT and Single it returns nothing.
=TEXTJOIN(", ",TRUE,IF(AND(Current_staff[Full name]="VACANT",Current_staff[Occupancy]="Single"),Current_staff[Office/desk number],""))
Apr 26 2021 08:48 AM
Apr 26 2021 09:00 AM
Apr 26 2021 09:01 AM
SolutionAND returns a single TRUE/FALSE value, not an array. Try
=TEXTJOIN(", ",TRUE,IF((Current_Staff[Full Name]="VACANT")*(Current_Staff[Occupancy]="Single"),Current_Staff[Office/desk number],""))
confirmed with Ctrl+Shift+Enter
Apr 26 2021 09:05 AM
Apr 26 2021 09:01 AM
SolutionAND returns a single TRUE/FALSE value, not an array. Try
=TEXTJOIN(", ",TRUE,IF((Current_Staff[Full Name]="VACANT")*(Current_Staff[Occupancy]="Single"),Current_Staff[Office/desk number],""))
confirmed with Ctrl+Shift+Enter