Published 12/2022MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 459.50 MB | Duration: 1h 12m

Master Smartsheet Formulas, Data Analysis and Reporting

What you'll learn

All of the most important Smartsheet formulas

How to create Smartsheet formulas from scratch

How to troubleshoot Smartsheet formulas that do not work

How to use Smartsheet formulas

Requirements

No Smartsheet experience is required, though you will need an active license to the platform

Description

Learn how to write, understand, use and troubleshoot formulas in Smartsheet to run calculations and automate reporting in this formula training course.I'll walk you through how I use formulas in Smartsheet to automate calculations on multi-million dollar projects (seamlessly). You'll learn exactly what formulas to use, when, and why. By the end, you will be able to write your own formulas, troubleshoot issues, and be confident your formulas are showing the right results.Whether you are brand new to Smartsheet or have been using it for some , this in-depth, thorough and clear Formula Training course documents everything you need to do, and consider.From initial considerations through to useful automation - by the end of this course, you'll be able to work with the advanced formulas of Smartsheet and even be able to copy and paste them to ensure they work right away!This Course Is Suitable ForProgram ManagersProject ManagersProject Team MembersGeneral Smartsheet UsersFuture Smartsheet UsersThis Course Is For You If You Want To...Save a significant amount of ,Dramatically reduce your learning curve,Automate your workflows,Optimize your account data,Help other team membersGet a better understanding of how Smartsheet works,Keep stakeholders informed,Improve your reporting capabilitiesSpark new ideas for KPIs to report on,See what is possible,Impress your boss/support your team,Among many others!

Overview

Section 1: Welcome To The Course

Lecture 1 Welcome

Lecture 2 What To Expect

Lecture 3 How To Get The Most Out Of The Course

Section 2: Intro to Formulas

Lecture 4 Formula Overview

Lecture 5 Where to use Formulas in Smartsheet

Section 3: Top Formulas To Know

Lecture 6 COUNT, COUNTIF, and COUNITIFS

Lecture 7 SUM, SUMIF and SUMIFs

Lecture 8 Replace

Lecture 9 Day and Date

Lecture 10 NetworkDays

Lecture 11 VLookups

Lecture 12 ISBLANK

Lecture 13 MAX

Lecture 14 MIN

Lecture 15 MEDIAN

Lecture 16 ROUND

Lecture 17 IF

Section 4: Advanced Formula Strats

Lecture 18 Nested Formulas

Section 5: Troubleshooting Formulas

Lecture 19 #BLOCKED

Lecture 20 #CALCULATING

Lecture 21 #INCORRECT ARGUMENT SET

Lecture 22 #NO MATCH

Lecture 23 #UNPARSEABLE

Section 6: Dashboards

Lecture 24 Dashboards

Smartsheet Users

HomePage: