Advanced Functions & Cross-sheet Formulas in Smartsheet

Advanced Functions & Cross-sheet Formulas in Smartsheet

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