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
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 201 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!