Meeting Minutes Filter – per published item formula
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.
So , if I change the meeting number, the X on the attendees list will also change based on the meeting number.
Answers
-
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))
-
It still came out as #unparseable. I will have to do a trial and error until it works. Thanks again.
-
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:
=INDEX([Hidden Cols -->]2:[Duration]2,1,MATCH([Assigned To]$2,[Hidden Cols -->]$2:[Duration]$2,0))
-
Try changing the first range's row numbers from "2" to "@row".
-
Thank you Paul, it worked!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!