Track budgets with Lucid org chart formulas

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:
https://www.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:
https://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:
https://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: 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/

Видео Track budgets with Lucid org chart formulas канала Lucid Software