Meeting Minutes Filter – per published item formula

RiKi

I have created a meeting minutes filter where when I select the published date (or meeting minute #) it will publish only the date of that particular meeting minute date it was created or any due date falling on that date.  

What I want to add is the attendees list for that date, where I want to put an X in a column to indicate the attendees for that particular date. I have helper columns where I mark up the attendees for a particular date, but this won't be seen in the actual published document to maintain a clean document. Given that this is a live document, has anyone tried creating a formula where the visible list of attendees will automatically show the actual attendees for a particular date if the meeting number is changed? The "X" beside their names would be a formula that shows the link coming from the helper column where I have the actual data of the attendance for that day. 

240312 SS Meeting Minutes template.png

240312 SS Meeting minutes filter.png

So , if I change the meeting number, the X on the attendees list will also change based on the meeting number. 

Paul Newcome

You would use something along the lines of:

=INDEX([First MM Column]@row:[Last MM Column]@row, 1, MATCH([Assigned To]$2, [First MM Column]$2:[Last MM Column]$2, 0))

RiKi

It still came out as #unparseable. I will have to do a trial and error until it works. Thanks again.

RiKi

I have tried experimenting on the formula, and this actually worked, however, it copied the meeting number on the attendance list, and not the X. What needs to be changed in the formula so it will copy the attendance tick? This was the formula that I used:

240314 MM Formula worked but not copying the X from 240306 column.png

=INDEX([Hidden Cols -->]2:[Duration]2,1,MATCH([Assigned To]$2,[Hidden Cols -->]$2:[Duration]$2,0)) 

Paul Newcome

Try changing the first range's row numbers from "2" to "@row".

RiKi

Thank you Paul, it worked!

Paul Newcome

Happy to help. 👍️