Smartsheet Tutorial: Formula Basics | Using Formulas to Create a Metrics Sheet for Dashboards
Looking to build dashboards in Smartsheet? This video illustrates how to set up formulas in Smartsheet so they can be pulled into metrics on dashboards.
Join Solution Consultant Kelly Pratt as she demonstrates:
1. How to reference multiple sheets in SumIF and CountIF formulas.
2. How to set up formulas so they don't break.
3. How to find formula error messages.
4. Types of formulas
5. Using multiple formulas
Looking for some guidance on your Smartsheet solution? Let's connect to see how we can help: https://www.echolocity.com/schedule-m...
Video Highlights
Start: 00:00
Functions List: 00:17
Creating a Metrics Sheet: 02:40
CountIFS: 04:45
Range: 05:17
Criteria: 06:19
➡️ Resources for You:
Our Website - https://echolocity.com/
Meet with Us - https://www.echolocity.com/schedule-m...
Our LinkedIn - / echo-consulting-pm
Subscribe Here: https://www.youtube.com/c/EchoConsult...
➡️ Recommended Playlists:
Microsoft 365 Tutorials & Tips → • Microsoft Feature Highlight: Improved Sear...
Smartsheet Tutorials & Tips → • Smartsheet Tip: Proofing
Monday.com Tutorials & Tips → • Monday.com: Tutorials & Tips
Asana Tutorials & Tips → • Asana Tutorials & Tips
ClickUp Tutorials & Tips → • ClickUp Tip: Tasks & Subtasks in Multiple ...
Project Management → • Getting Started with a Project Management ...
Webinars → • Webinar: Selfcare & Wellness