Procedure calendar

Options

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),"")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!