Advanced Functions & Cross-sheet Formulas in Smartsheet

Advanced Functions & Cross-sheet Formulas in Smartsheet

Not currently available

About this course

Within these lessons, you will learn about advanced functions like SUMIF, COUNTIF, VLOOKUP, INDEX and MATCH, as well as how to use these functions across multiple sheets.

Curriculum

  • Course Introduction
  • COUNTIF & SUMIF Functions
  • Introduction to Cross-sheet Formulas
  • VLOOKUP Function
  • INDEX & MATCH Functions
  • Course Evaluation

About this course

Within these lessons, you will learn about advanced functions like SUMIF, COUNTIF, VLOOKUP, INDEX and MATCH, as well as how to use these functions across multiple sheets.

Curriculum

  • Course Introduction
  • COUNTIF & SUMIF Functions
  • Introduction to Cross-sheet Formulas
  • VLOOKUP Function
  • INDEX & MATCH Functions
  • Course Evaluation