Procedure calendar

bburge

I want to write a formula that allows the results of two different rows to be 'merged' into one cell of another worksheet. Is this possible? This spreadsheet is used by multiple people on desktop and mobile devices, and as it is now, the formula will only match one date per bed, but I want to be able to match all entries. In the workbook, there is a tab where a provider or nurse can enter the date, the room number, and the procedure for each patient (tab is 'procedurelist'), and this information populates onto the weekly schedule tab so the team can see the full-day cleaner (weekly procedure schedule).

The current formula is =IFERROR(INDEX(TaskList,MATCH($E$4&$B6,TaskList[[ ]],0),3),"")

Paul Newcome

You will most likely want a JOIN/COLLECT along the lines of

=JOIN(COLLECT({Source Sheet Procedure}, {Source Sheet Bed}, @cell = Bed@row, {Source Sheet Date}, @cell = DATE(yyyy,mm,dd)), CHAR(10))

bburge

If I attach the spreadsheet, would you be willing to assist?

Paul Newcome

Did you try the formula above? You should just need to create each {Cross Sheet Reference} following the appropriate steps and replace yyyy, mm, dd in the DATE function with the applicable date.