Uploaded April 2026 | Updated November 2026, 5 hours ago
Master date-based data analysis in Lucid using Google Sheets and smart formulas. This tutorial shows you how to build a dynamic date range picker directly on your canvas to filter records like recruitment applicants. Learn to split text strings into valid date arrays and use the lookup and filter functions to count items received between specific lower and upper dates. These techniques allow you to create real-time reports and visual dashboards that update instantly as you adjust your timeline.
Try intelligent diagramming:
lucidchart.com
This video was made around or before 2024. The UI might look different today, but the functionality should still work.
*Timestamps*
0:00 Introduction to date filtering
0:40 Link Google Sheets to Lucid
1:01 Set up input fields for date ranges
1:23 Use split formulas for date strings
1:42 Convert text to date objects
3:00 Reference unique page properties
3:40 Count items within a date range
5:10 Sync and update dynamic date reports
*Recommended resources*
How to link data to Lucid documents:
help.lucid.co/hc/en-us/articles/16493391394068-Link-data-to-a-Lucidchart-document
Lucid formula guide for dates:
help.lucid.co/hc/en-us/articles/15179329448596-Use-formulas-in-Lucidchart
#Lucidchart #DataAnalysis #WorkflowAutomation #recruiting
*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
Master date-based data analysis in Lucid using Google Sheets and smart formulas. This tutorial shows you how to build a dynamic date range picker directly on your canvas to filter records like recruitment applicants. Learn to split text strings into valid date arrays and use the lookup and filter functions to count items received between specific lower and upper dates. These techniques allow you to create real-time reports and visual dashboards that update instantly as you adjust your timeline.
Try intelligent diagramming:
lucidchart.com
This video was made around or before 2024. The UI might look different today, but the functionality should still work.
*Timestamps*
0:00 Introduction to date filtering
0:40 Link Google Sheets to Lucid
1:01 Set up input fields for date ranges
1:23 Use split formulas for date strings
1:42 Convert text to date objects
3:00 Reference unique page properties
3:40 Count items within a date range
5:10 Sync and update dynamic date reports
*Recommended resources*
How to link data to Lucid documents:
help.lucid.co/hc/en-us/articles/16493391394068-Link-data-to-a-Lucidchart-document
Lucid formula guide for dates:
help.lucid.co/hc/en-us/articles/15179329448596-Use-formulas-in-Lucidchart
#Lucidchart #DataAnalysis #WorkflowAutomation #recruiting
*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

![Lean Canvas tutorial: How to build your own with Lucid
Build a better business strategy with this guide to the Lean Canvas. This one-page template helps startups deconstruct ideas and document risky assumptions quickly. Unlike a traditional business model canvas, it focuses on specific customer pain points and your unique unfair advantage. Use Lucid to collaborate with your team in real time and turn your ideas into an actionable plan.
Learn more about Lucid and sign up for a free account today:
https://lucid.co/try-now
*Timestamps*
0:00 What is a Lean Canvas?
0:21 Lean Canvas vs. business model canvas
0:34 Why use a Lean Canvas?
0:45 The nine building blocks of a Lean Canvas
0:54 Problem and customer segments
1:01 Identify your unfair advantage
1:12 Revenue, cost, and key metrics
1:24 Common mistakes to avoid
1:37 SaaS startup example
1:47 Step-by-step tutorial in Lucid
*Recommended resources*
[Blog] How to make a Lean Canvas model:
https://www.lucidchart.com/blog/lean-canvas-model
[Template] Lean Canvas model:
https://lucid.co/templates/lean-canvas-model?p=1
[Training] Lucid Training Labs:
https://training.lucid.co/
#LeanCanvas #Lucid #StartupStrategy #BusinessModel
*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/ Lean Canvas tutorial: How to build your own with Lucid](https://i.ytimg.com/vi/XsAWSqfn6o0/mqdefault.jpg)




![Affinity diagram tutorial: How to build your own with Lucidspark
Use affinity diagrams to turn brainstormed ideas into actionable insights using Lucid. This tutorial covers how to organize large data sets into logical groups to simplify complex problems and identify priorities. Learn to use intelligent features in Lucidspark, like the gather tool and sticky note import, to build your diagram quickly.
Learn more about Lucidspark and sign up for a free account today:
https://lucid.app/pricing/lucidspark
*Timestamps*
0:00 What is an affinity diagram?
0:23 When to use affinity mapping
0:35 Benefits of affinity mapping
0:45 Key elements of an affinity diagram
0:56 Best practices for building diagrams
1:07 Using affinity mapping in Agile
1:17 Step-by-step tutorial in Lucid
1:28 Gather your data
1:33 Import sticky notes
1:40 Sort and group ideas
1:46 Create categories and frames
*Recommended resources*
[Blog] Affinity diagrams: Your key to more creative problem solving
https://lucid.co/blog/affinity-diagrams-your-key-to-more-creative-problem-solving
[Template] Affinity diagram:
https://lucid.co/templates/affinity-diagram-template
[Training] Basics in Lucidspark:
https://training.lucid.co/basics-in-lucidspark
#AffinityDiagram #Lucid #Agile #Brainstorming #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/ Affinity diagram tutorial: How to build your own with Lucidspark](https://i.ytimg.com/vi/YdqGhEpZbQc/mqdefault.jpg)
![Lucidspark Fundamentals | Brainstorming | Creating a repository
Learn how to keep a running record of your ideas in Lucidspark. This course covers how to use revision history, the table of contents, and AI to summarize your board. You can also move content to breakout boards to organize subsequent brainstorming sessions. These tools help your team cut through the fluff and focus on the main results of your initial brainstorm.
Earn your Lucidspark Fundamentals Builder Badge:
https://training.lucid.co/path/lucidspark-fundamentals
*Timestamps*
0:00 Welcome to brainstorming workflows
0:41 How to use revision history
1:18 Naming board versions
1:48 Navigating with the table of contents
2:20 Summarizing with AI in Lucidspark
3:14 Moving content to breakout boards
4:18 Reviewing breakout board records
*Recommended resources*
[Training] Go to Lucid Training Labs for more self-serve courses and live training workshops
https://training.lucid.co/
[Help center] Get started with Lucidspark
https://help.lucid.co/hc/en-us/articles/11973407023636-Welcome-to-Lucidspark
[Templates] Explore brainstorming templates
https://lucid.co/templates/brainstorming
#Lucidspark #Brainstorming #WorkAcceleration #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/ Lucidspark Fundamentals | Brainstorming | Creating a repository](https://i.ytimg.com/vi/Ysxwwn7FCxE/mqdefault.jpg)


