Smartsheet Formula Training Course

0

1

2

3

4

5

Posted on 17 Dec 07:58 | by mitsumi | 76 views

Published 12/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: 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 time, 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 time,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 Strategies
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