Uploaded April 2026 | Updated November 2026, 1 day ago
This video explains how to add salary and budget data to an org chart in Lucidchart. It covers importing data from a Google Sheet and using global formulas like "downstream" and "downstream deep" to dynamically calculate team salary totals based on direct reports or all subordinates in the hierarchy. It also demonstrates how to format these calculated totals as currency and how to apply conditional formatting rules that display a red alert icon when a manager's team salary exceeds their allocated budget. Finally, the video highlights that spreadsheet data can be easily refreshed while the custom formulas and rules remain in place, making it an ideal document to save as a repeatable template.
Create intelligent org charts:
lucidchart.com/pages/use-cases/visual-organizations
This video was made around or before 2024. The UI might look different today, but the functionality should still work.
*Timestamps*
0:00 Adding salary data to org charts
0:40 Creating custom employee fields
1:21 Summing downstream salaries
2:03 Using downstream deep formulas
3:11 Moving people and dynamic updates
3:48 Conditional formatting for budgets
5:26 Refreshing data from Google Sheets
*Recommended resources*
Importing Google Sheets as org charts:
help.lucid.co/hc/en-us/articles/44818725952276-How-do-I-import-an-org-chart-from-a-CSV-Excel-file-or-Google-Sheet
Using formulas in Lucid:
help.lucid.co/hc/en-us/articles/15179329448596-Use-formulas-in-Lucidchart
#BudgetTracking #Lucidchart #Leadership #DataLinking #BusinessTransformation
*About Lucid*
Lucid Software is the leader in visual collaboration and work acceleration, helping teams turn ideas into reality. Its Visual Collaboration Suite (Lucidchart and Lucidspark) and airfocus, an AI-powered product management platform, help organizations streamline work, foster alignment, and drive business transformation. The most used work acceleration platform by the Fortune 500, Lucid is trusted by 100M+ users worldwide.
đź”” Subscribe for more tips and tutorials: youtube.com/@lucid_software?sub_confirmation=1
*Connect with us*
Facebook: facebook.com/lucidsoftware
Twitter: https://x.com/lucidsoftware
Instagram: instagram.com/lucidsoftware/#
LinkedIn: linkedin.com/company/lucidsoftware
This video explains how to add salary and budget data to an org chart in Lucidchart. It covers importing data from a Google Sheet and using global formulas like "downstream" and "downstream deep" to dynamically calculate team salary totals based on direct reports or all subordinates in the hierarchy. It also demonstrates how to format these calculated totals as currency and how to apply conditional formatting rules that display a red alert icon when a manager's team salary exceeds their allocated budget. Finally, the video highlights that spreadsheet data can be easily refreshed while the custom formulas and rules remain in place, making it an ideal document to save as a repeatable template.
Create intelligent org charts:
lucidchart.com/pages/use-cases/visual-organizations
This video was made around or before 2024. The UI might look different today, but the functionality should still work.
*Timestamps*
0:00 Adding salary data to org charts
0:40 Creating custom employee fields
1:21 Summing downstream salaries
2:03 Using downstream deep formulas
3:11 Moving people and dynamic updates
3:48 Conditional formatting for budgets
5:26 Refreshing data from Google Sheets
*Recommended resources*
Importing Google Sheets as org charts:
help.lucid.co/hc/en-us/articles/44818725952276-How-do-I-import-an-org-chart-from-a-CSV-Excel-file-or-Google-Sheet
Using formulas in Lucid:
help.lucid.co/hc/en-us/articles/15179329448596-Use-formulas-in-Lucidchart
#BudgetTracking #Lucidchart #Leadership #DataLinking #BusinessTransformation
*About Lucid*
Lucid Software is the leader in visual collaboration and work acceleration, helping teams turn ideas into reality. Its Visual Collaboration Suite (Lucidchart and Lucidspark) and airfocus, an AI-powered product management platform, help organizations streamline work, foster alignment, and drive business transformation. The most used work acceleration platform by the Fortune 500, Lucid is trusted by 100M+ users worldwide.
đź”” Subscribe for more tips and tutorials: youtube.com/@lucid_software?sub_confirmation=1
*Connect with us*
Facebook: facebook.com/lucidsoftware
Twitter: https://x.com/lucidsoftware
Instagram: instagram.com/lucidsoftware/#
LinkedIn: linkedin.com/company/lucidsoftware
![Fishbone diagram tutorial: How to build your own with Lucidchart
Conduct root cause analysis with this fishbone diagram tutorial. We explain how the fishbone diagram, also known as an Ishikawa diagram, helps teams identify process bottlenecks and categorize potential causes using frameworks like the 6 Ms or 4 Ps. Learn how to combine this visual tool with the 5 Whys for deeper insights and follow our step-by-step guide to build your own structured layout in Lucidchart.
Learn more about Lucidchart and sign up for a free account today:
https://www.lucidchart.com
*Timestamps*
0:16 What is a fishbone or Ishikawa diagram?
0:28 Common use cases for root cause analysis
0:42 Categorizing causes with the 6 Ms and 4 Ps
1:18 Fishbone vs. the 5 whys
1:33 Best practices for facilitating a root cause analysis
1:47 Step-by-step tutorial in Lucidchart
*Recommended resources*
[Guide] What is a fishbone diagram?
https://www.lucidchart.com/pages/tutorial/what-is-a-fishbone-diagram
[Template] Ishikawa diagram example:
https://lucid.co/templates/ishikawa-diagram-example?p=1
[Training] Basics in Lucidchart course:
https://training.lucid.co/basics-in-lucidchart
#Lucidchart #FishboneDiagram #RootCauseAnalysis #IshikawaDiagram #VisualCollaboration
*About Lucid*
Lucid Software is the leader in visual collaboration and work acceleration, helping teams turn ideas into reality. Its Visual Collaboration Suite (Lucidchart and Lucidspark) and airfocus, an AI-powered product management platform, help organizations streamline work, foster alignment, and drive business transformation. The most used work acceleration platform by the Fortune 500, Lucid is trusted by 100M+ users worldwide.
đź”” Subscribe for more tips and tutorials: https://www.youtube.com/@lucid_software?sub_confirmation=1
*Connect with us*
Facebook: https://www.facebook.com/lucidsoftware
Twitter: https://x.com/lucidsoftware
Instagram: https://www.instagram.com/lucidsoftware/#
LinkedIn: https://www.linkedin.com/company/lucidsoftware/ Fishbone diagram tutorial: How to build your own with Lucidchart](https://i.ytimg.com/vi/PhL6bQQEm7E/mqdefault.jpg)



![Circuit diagram tutorial: How to build your own with Lucidchart
Create professional schematics with ease using Lucidchart. This tutorial covers essential symbols—from power sources to control elements—and best practices for building clean, readable circuit diagrams. Learn how to differentiate between schematics, wiring, and pictorial diagrams while focusing on logical connections rather than physical layout. With our smart connector tool and automated grid alignment, you can iterate on designs in real time with your team.
Learn more about Lucidchart and sign up for a free account today:
https://www.lucidchart.com
*Timestamps*
0:00 What is a circuit diagram?
0:27 Schematic vs. wiring vs. pictorial diagrams
0:43 Common circuit diagram symbols
1:00 How to read a circuit diagram
1:15 Best practices for clean and readable schematic design
1:35 Step-by-step tutorial: How to draw a circuit diagram
*Recommended resources*
[Guide] How to create a circuit diagram:
https://www.lucidchart.com/pages/how-to-create-circuit-diagram
[Guide] Circuit diagram symbols:
https://www.lucidchart.com/pages/circuit-diagram-symbols
[Training] Basics in Lucidchart course:
https://training.lucid.co/basics-in-lucidchart
#CircuitDiagram #ElectricalEngineering #Lucidchart #SchematicDesign #Engineering
*About Lucid*
Lucid Software is the leader in visual collaboration and work acceleration, helping teams turn ideas into reality. Its Visual Collaboration Suite (Lucidchart and Lucidspark) and airfocus, an AI-powered product management platform, help organizations streamline work, foster alignment, and drive business transformation. The most used work acceleration platform by the Fortune 500, Lucid is trusted by 100M+ users worldwide.
đź”” Subscribe for more tips and tutorials: https://www.youtube.com/@lucid_software?sub_confirmation=1
*Connect with us*
Facebook: https://www.facebook.com/lucidsoftware
Twitter: https://x.com/lucidsoftware
Instagram: https://www.instagram.com/lucidsoftware/#
LinkedIn: https://www.linkedin.com/company/lucidsoftware/ Circuit diagram tutorial: How to build your own with Lucidchart](https://i.ytimg.com/vi/RRzPcNAtSbE/mqdefault.jpg)

![Empathy map tutorial: How to build your own with Lucidspark
Learn how to use empathy maps to gain a deep understanding of your customers. This collaborative tool, often called a lean user persona, helps product and marketing teams externalize user knowledge to create a shared vision. We break down the four quadrants—says, thinks, does, and feels—and show you how to identify pains and gains to build features your users actually need.
Learn more about Lucidspark and sign up for a free account today:
https://lucid.app/pricing/lucidspark
*Timestamps*
0:00 What is an empathy map?
0:28 Empathy maps vs. user personas
0:41 The four quadrants: Says, thinks, does, feels
1:02 Identifying pains and gains
1:18 When to use an empathy map
1:32 How to conduct a mapping session
1:44 Step-by-step tutorial in Lucidspark
1:56 Using collaborative AI to summarize research
2:11 Why use empathy mapping?
*Recommended resources*
[Blog] How to create an empathy map:
https://lucid.co/blog/how-to-create-an-empathy-map
[Template] Empathy map example:
https://lucid.co/templates/empathy-map-template?p=1
[Training] Basics in Lucidspark:
https://training.lucid.co/basics-in-lucidspark
#EmpathyMaps #DesignThinking #Lucidspark #UXDesign #UserResearch #ProductManagement
*About Lucid*
Lucid Software is the leader in visual collaboration and work acceleration, helping teams turn ideas into reality. Its Visual Collaboration Suite (Lucidchart and Lucidspark) and airfocus, an AI-powered product management platform, help organizations streamline work, foster alignment, and drive business transformation. The most used work acceleration platform by the Fortune 500, Lucid is trusted by 100M+ users worldwide.
đź”” Subscribe for more tips and tutorials: https://www.youtube.com/@lucid_software?sub_confirmation=1
*Connect with us*
Facebook: https://www.facebook.com/lucidsoftware
Twitter: https://x.com/lucidsoftware
Instagram: https://www.instagram.com/lucidsoftware/#
LinkedIn: https://www.linkedin.com/company/lucidsoftware/ Empathy map tutorial: How to build your own with Lucidspark](https://i.ytimg.com/vi/SD5rOMqv6n0/mqdefault.jpg)
![Service blueprint tutorial: How to build your own with Lucidchart
Improve your customer experience by visualizing the internal skeleton of your service. In this tutorial, we explore how service blueprints identify inefficiencies and align your team around the customer journey. Learn the difference between onstage and backstage actions and see how to build your own diagram using Lucidchart’s intelligent diagramming features.
Learn more about Lucidchart and sign up for a free account today:
https://www.lucidchart.com
*Timestamps*
0:00 What is a service blueprint?
0:26 Why use a service blueprint?
0:40 Service blueprint vs. journey map
0:52 Key components and layers
1:02 Onstage vs. backstage actions
1:26 Step-by-step tutorial in Lucidchart
1:54 Real-time collaboration
*Recommended resources*
[Guide] What is a service blueprint?
https://www.lucidchart.com/blog/what-is-a-service-blueprint
[Template] Service blueprint with swimlanes:
https://lucid.co/templates/service-blueprint-with-swimlanes?p=1
[Training] Basics in Lucidchart course:
https://training.lucid.co/basics-in-lucidchart
#ServiceBlueprint #Lucidchart #CustomerExperience #VisualCollaboration
*About Lucid*
Lucid Software is the leader in visual collaboration and work acceleration, helping teams turn ideas into reality. Its Visual Collaboration Suite (Lucidchart and Lucidspark) and airfocus, an AI-powered product management platform, help organizations streamline work, foster alignment, and drive business transformation. The most used work acceleration platform by the Fortune 500, Lucid is trusted by 100M+ users worldwide.
đź”” Subscribe for more tips and tutorials: https://www.youtube.com/@lucid_software?sub_confirmation=1
*Connect with us*
Facebook: https://www.facebook.com/lucidsoftware
Twitter: https://x.com/lucidsoftware
Instagram: https://www.instagram.com/lucidsoftware/#
LinkedIn: https://www.linkedin.com/company/lucidsoftware/ Service blueprint tutorial: How to build your own with Lucidchart](https://i.ytimg.com/vi/Sq4Ik31kamY/mqdefault.jpg)


