Breakout Session

Advanced data retrieval with INDEX, MATCH, and COLLECT

Thursday, Nov 6 | 4:00PM - 5:00PM

Details

Enhance your Smartsheet data connections by going beyond exact match lookup formulas. Discover the enduring relevance of INDEX, MATCH, and COLLECT functions for complex data retrieval. We'll explore how these robust functions enable you to perform sophisticated lookups, find approximate matches, automatically group data, and extract precisely the information you need using multiple criteria for pinpoint accuracy.

	Content Track Scale at any stage
	User Level Advanced
	PMI Credits 1
	Industry All Industries

Speakers

Courtney Lake

Technical Trainer

Courtney’s journey with Smartsheet started as a enthusiastic customer in 2017. After years using the product daily and building solutions across her company, she turned that passion into a career as a Technical Trainer on the Smartsheet team in 2021. She loves diving into complex formulas and troubleshooting tricky sheet setups, and her favorite part of the job is seeing the "aha!" moment when someone discovers a new way to streamline their work. She focuses on creating engaging and practical training sessions that empower others to become Smartsheet experts.