In this video, you will learn how to remove duplicate values from a Smartsheet database using formulas and automated workflows. In addition, you will discover how to use Conditional Formatting to help us identify duplicate data quicker.
Be sure to check out the timeline links below to jump to the section you’re interested in.
VIDEO TIMELINE
– 00:00 – Intro
– 00:05 – Question from the Smartsheet Community
– 00:45 – Setting Up Sample Data
– 01:05 – Section 1: Creating Formulas to Count Duplicates and Check Boxes
– 07:55 – Section 2: Capture Unique Data Points (IDs) Only Associated with Duplicate Values
– 10:45 – Section 3: Use Logical Formulas to Rank Duplicates and Isolate All But One
– 14:15 – Section 4: Set Up Automated Workflow to Remove Identified Duplicates
– 17:30 – Summary and Alts to the Formula
– 18:35 – Outro
– 00:05 – Question from the Smartsheet Community
– 00:45 – Setting Up Sample Data
– 01:05 – Section 1: Creating Formulas to Count Duplicates and Check Boxes
– 07:55 – Section 2: Capture Unique Data Points (IDs) Only Associated with Duplicate Values
– 10:45 – Section 3: Use Logical Formulas to Rank Duplicates and Isolate All But One
– 14:15 – Section 4: Set Up Automated Workflow to Remove Identified Duplicates
– 17:30 – Summary and Alts to the Formula
– 18:35 – Outro
If you’re interested in working with us, fill out our new client interest form HERE.
After submitting the form, you’ll have the opportunity to schedule a no-obligation 30-minute project exploration call to discuss your needs and see if we’re the right fit to help.
Resources:
- Try Smartsheet free for 30 days
- Want to work with us? Fill out our new client interest form
- Learn more about us here
