Track budgets with Lucid org chart formulas @lucid_software
Track budgets with Lucid org chart formulas  @lucid_software
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
Track budgets with Lucid org chart formulasFishbone diagram tutorial: How to build your own with LucidchartLucidchart Fundamentals | Basics | ShareHow non-technical teams use Lucid: New examples to inspire your workTrack active layers with the isVisible formulaCircuit diagram tutorial: How to build your own with LucidchartAgility Accelerator Overview VideoEmpathy map tutorial: How to build your own with LucidsparkService blueprint tutorial: How to build your own with LucidchartLately @ Lucid: Unlocking intelligence across the Lucid SuiteLucidchart Fundamentals | Process diagrams | ShareLucidchart Fundamentals | Technical systems | Draft
Lucid Software |

Track budgets with Lucid org chart formulas

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER