Here is my problem:
I have 2 standing meeting slots, one on the morning and one in the afternoon. A meeting can be scheduled during the morning, during the afternoon, both, or none.
Here is my need:
I wanted to show if there is a meeting in either slot on a given day. Right now I can show if one meeting slot is filled but when I try and fill the 2nd meeting slot is does not update.
My progress:
For the am meeting column:
=IFERROR(IF(CONTAINS("am", INDEX({Meeting Time}, MATCH([Meeting Date]@row, {Meeting Dates}, 0))), INDEX({Meeting Time}, MATCH([Meeting Date]@row, {Meeting Dates}, 0)), ""), " ")
For the PM meeting Column:
=IFERROR(IF(CONTAINS("pm", INDEX({Meeting Time}, MATCH([Meeting Date]@row, {Meeting Dates}, 0))), INDEX({Meeting Time}, MATCH([Meeting Date]@row, {Meeting Dates}, 0)), ""), " ")
Both currently work for a single value. If a second 10/22 date is entered but 1-3pm is entered the column does not update.
What am I missing or where is my mistake?