I am trying to automatically populate the “working with” column with the names of the people that are scheduled for the same shift (ie. location, date, start time which all match). For this example table below John, Bob & Josh would be working together.
Thanks!
Here you go. It assumes that Name is unique. If it is not, you should add (and hide) a new column with RowId() formula and use it in formula instead of Name.
1 Like
Dear @Denis_Peshekhonov, thanks for this sample 
, I was also working on it, but I didn’t manage to get my head around it. 
Always great to get the oppertunity to learn something new 
1 Like
Awesome! That is great. Thank you 
You are welcome!
P.S. I’ve realised that I forgot about location 
Added it to the formula.