Session 2: COLLECT Mastery: Smartsheet’s Most Powerful Function You’re Probably Not Using: A 3-Part Master Class Series

We Save You Time!
48:34
Paul Newcome and the 10xViz Team Show You How the Smartest Builders Use COLLECT
If you use metrics, dashboards, or reports, don’t miss this.
COLLECT is the secret weapon behind the smartest Smartsheet solutions, yet it remains one of the most underutilized functions in the platform. When used correctly, it becomes the engine behind dynamic dashboards, live metric sheets, and clean, reliable reporting.
In this 3-part Master Class, join Smartsheet Community legend Paul Newcome and the expert team at 10xViz as they guide you through real use cases and dashboards, diving progressively deeper in each session. Whether you're new to COLLECT or looking to master advanced formula logic, this series will equip you with the skills to build faster, cleaner, and smarter in Smartsheet.
Session 1: COLLECT Demystified
What It Is, When to Use It, and Why It Changes the Game
See COLLECT in action with real-world dashboards and sheet setups. Understand the logic, syntax, and use cases where COLLECT outperforms traditional references.
Session 2: Advanced Functions with COLLECT
Let's work with JOIN, SMALL, LARGE, and AVG.
Get into advanced use cases for COLLECT including advanced date filtering and multi-select.
Session 3: COLLECT Mastery in the Wild
Layered Logic, Pro Tips, and Real Solutions from Paul and the 10xViz Team
This advanced session goes deep with compound formulas, nested logic, and production-level dashboards. Watch how the experts solve real client challenges using COLLECT in ways most users never consider.
Speakers
Paul Newcome
Smartsheet Solutioner
Paul Newcome is a Smartsheet Certified Solution Consultant at 10xViz, renowned for his exceptional ability to blend big-picture vision with meticulous attention to detail. As the #1 contributor to the Smartsheet Online Community, Paul consistently offers valuable insights, answers questions, and shares best practices, demonstrating his commitment to building powerful Smartsheet solutions as well as community engagement.
Dustin Wise
Director of Solution Innovation
Dustin Wise brings over 16 years of experience in engineering, operations, and leadership to his role as Director of Solution Innovation at 10xViz. Known for his innovative mindset and creative problem-solving, Dustin leads client engagement and team leadership efforts, focusing on delivering automated, efficient solutions that transform the way organizations work. His collaborative spirit, curiosity, and ability to inspire action align with 10xViz's mission to empower clients with smarter workflows, enhanced visibility, and measurable results—returning their most valuable resource: time.
Jennifer Jones
CEO
Jennifer Jones (JJ) is the CEO and Founder of 10xViz, a Smartsheet Platinum Partner, dedicated to revolutionizing the way people work. With over 20 years of experience, Jennifer has helped organizations achieve greater efficiency, visibility, and collaboration—delivering measurable impacts to the bottom line. As a sought-after speaker, Jennifer enjoys sharing her expertise in leveraging technology to streamline workflows, bridge communication gaps, and drive meaningful results. She is passionate about empowering teams to work smarter, not harder.
Replays
See all
Session 2: COLLECT Mastery: Smartsheet’s Most Powerful Function You’re Probably Not Using: A 3-Part Master Class Series
48:34