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-meeting 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-meeting Our LinkedIn - https://www.linkedin.com/company/echo-consulting-pm/ Subscribe Here: https://www.youtube.com/c/EchoConsulting?sub_confirmation=1 ➡️ Recommended Playlists: Microsoft 365 Tutorials & Tips → https://www.youtube.com/watch?v=meWGjWvNc3Q&list=PLO3D1ido-Qg7i3llBtnGkWI_rOF1x-r3V Smartsheet Tutorials & Tips → https://www.youtube.com/watch?v=DQazpDmRWis&list=PLO3D1ido-Qg6eBqKtnAtWk3iJS_-mpyiX Monday.com Tutorials & Tips → https://www.youtube.com/playlist?list=PLO3D1ido-Qg4aMalxkqUNRML-iB387tqu Asana Tutorials & Tips → https://www.youtube.com/playlist?list=PLO3D1ido-Qg783975SGf7SIW0AtH6VASs ClickUp Tutorials & Tips → https://www.youtube.com/watch?v=7rCwzCVSP7I&list=PLO3D1ido-Qg6X1Mv27JAgxCm17xxbauvM Project Management → https://www.youtube.com/watch?v=ozVgrvT9BlU&list=PLO3D1ido-Qg7P_Cxs2CAIm6dW55LNPpKf Webinars → https://www.youtube.com/watch?v=n2LH1Gytj5g&list=PLO3D1ido-Qg4Evvvww8gtUgVgc05f2Qup