Pulling a list of users who are taking a course

topazfae ✭✭✭
edited 07/12/23 in Formulas and Functions

I need assistance with creating an automated report for each course in my spreadsheet. The spreadsheet contains information about courses and learners. Instead of manually creating reports for over 100 courses, I want to establish a link from each course entry that leads to a report or filtered spreadsheet listing the participants.

Essentially, I'm looking for a solution where, in the main spreadsheet, I can click on a course link and be directed to a report or filtered spreadsheet displaying the participants for that specific course. Could someone help me devise a method to achieve this?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!