Forum Discussion
Solved
TEXTJOIN AND not working
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. =T...
AND 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
AND 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
- Thank you, that worked. I've been going crazy over this for weeks. 🙂
