Formulas in Lucid

Make your diagrams intelligent using formulas

rate limit

Code not recognized.

About this course

In this course, you'll learn: 

  • Where to find advanced data and how to use formula features to make documents more intelligent
  • How to write a basic formula that sums up information in the document
  • How to apply data to custom shapes and groups
  • How to write and apply conditional formatting rules

Who is this course for?

  • Intermediate to advanced Lucidchart users
  • Anyone who is looking to work with more advanced features in Lucidchart
  • Users who have experience with Excel/Google Sheets formulas and Java script
  • Users should have a knowledge of using formulas with "if" statements, sums, averages, etc. 

 

Features covered in this course: Formulas, formulas editor, data-linking, data panel, custom group shapes (with data), conditional formatting, advanced conditional formatting, dynamic shapes. 
Note: There may be features in the activities that are not available to you depending on your license level.
Reach out to your admin to learn more about your Lucid license or visit the Lucid Help center
(Lucidchart plans) to learn more!


For the best experience, you'll want to have: 

  • Google Chrome browser
  • A Lucid account
  • Headphones or speakers

Curriculum38 min

  • Navigating Lucid Training Labs
  • Navigating Lucid Training Labs
  • Why formulas?
  • Why formulas? 5 min
  • Lucid formula basics
  • How data is used in Lucid + Lucid lingo 8 min
  • Geography and tools 15 min
  • Getting your data into Lucid
  • Referencing data in Lucid
  • Intro to Lucid referencing
  • Parent child relationships within Lucid
  • Line formulas in Lucid
  • Container formulas in Lucid
  • Shape ID referencing
  • Lab | Practice using formulas with an expert
  • Digital workbook | Working with data and formulas 10 min
  • Lab | Use-cases and examples
  • Wrap Up
  • Feedback

About this course

In this course, you'll learn: 

  • Where to find advanced data and how to use formula features to make documents more intelligent
  • How to write a basic formula that sums up information in the document
  • How to apply data to custom shapes and groups
  • How to write and apply conditional formatting rules

Who is this course for?

  • Intermediate to advanced Lucidchart users
  • Anyone who is looking to work with more advanced features in Lucidchart
  • Users who have experience with Excel/Google Sheets formulas and Java script
  • Users should have a knowledge of using formulas with "if" statements, sums, averages, etc. 

 

Features covered in this course: Formulas, formulas editor, data-linking, data panel, custom group shapes (with data), conditional formatting, advanced conditional formatting, dynamic shapes. 
Note: There may be features in the activities that are not available to you depending on your license level.
Reach out to your admin to learn more about your Lucid license or visit the Lucid Help center
(Lucidchart plans) to learn more!


For the best experience, you'll want to have: 

  • Google Chrome browser
  • A Lucid account
  • Headphones or speakers

Curriculum38 min

  • Navigating Lucid Training Labs
  • Navigating Lucid Training Labs
  • Why formulas?
  • Why formulas? 5 min
  • Lucid formula basics
  • How data is used in Lucid + Lucid lingo 8 min
  • Geography and tools 15 min
  • Getting your data into Lucid
  • Referencing data in Lucid
  • Intro to Lucid referencing
  • Parent child relationships within Lucid
  • Line formulas in Lucid
  • Container formulas in Lucid
  • Shape ID referencing
  • Lab | Practice using formulas with an expert
  • Digital workbook | Working with data and formulas 10 min
  • Lab | Use-cases and examples
  • Wrap Up
  • Feedback