Meeting Minutes - automate MM#, author and attendees by date


Hi All,

Hope you're all well.

I wanted to filter the meeting minutes based on the selected date. I created hidden columns that contain the meeting number, author and actual attendees for that date. I tried using the formula below but it didn't work. The peach background means this is where I change the date manually, which will then automate the MM#, author and attendees once it matches with the date in the hidden columns. I am using the formula below:

=INDEX([Hidden Cols -->]$2:Duration$4, 3, MATCH([Date Added]$2, [Hidden Cols -->]$4:Duration$4, 0))

I'm not sure what I should have changed.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!