SBP’s Smarter Dropdown List Manager: a small investment with a big impact

Smarter training adjusted to suit your real needs

At Smarter Business Processes we offer a wide variety of Smartsheet training courses and packages.

Our team of certified consultants provides training and remote support to clients around the globe, improving their Project Management, Workflow and Process Management.

Emma Stevens

Office Manager

Emma has 27 years of financial and customer experience and brings processes and order to our office.

Emma's customer service knowledge ensures all of our clients office enquiries are dealt with professionally, efficiently and quickly. She will leave no stone unturned to get to the bottom of a query!

When not at her desk Emma enjoys spending time with her husband and daughter as well running Brownies and Rainbows for Girlguiding UK in her local area.

Etienne Mermillod

Software Development Manager

Etienne is a seasoned ASP.NET Core Full Stack Developer. He takes great pride in building world-class applications while carefully considering the needs of its users and ease of use.

Originally from France, Etienne now calls Canada Home, where he is part of SBP Canada as a member of the API Solutions Development Team.

Etienne is a well-seasoned traveler and has visited many countries where he usually takes the path less traveled in order to backpack around and soak in the local cultures.

When not coding away, you may expect Etienne to be playing with his huge and fluffy dog Indianna or gaming away on League of Legends

David Bower

Smartsheet, Airtable and AppSheet Consultant

David is a hugely experienced Consultant, Customer Care Specialist and Client Account Manager.

In his spare time, David plays guitar, is learning to ride a motorcycle and, when it’s not too cold, can often be found tinkering in the garage. He also intends to learn to play the piano too - one day

Debbie Sawyer

Chief Smartsheet Solutions Officer (CSSO)

BSc (Hons) Computing, ITIL Foundation, Smartsheet Certified User, Aligned Sales Certified and Professional Services Certified.

Seasoned Smartsheet consultant and Training professional, Debbie’s creativity, attention to detail, willingness to deliver solutions to fully meet customer requirements and her personable manner earn her excellent client feedback.

When not working, Debbie likes to relax by spending quality time with her family. Living in the New Forest sees her taking many walks through the woods and down to the sea fronts at Lepe and Calshot. Debbie is also a keen hula hooper and has been hooping now for more than 7 years! She owns at least 10 hoops and enjoys a great workout helping her friend to run a hula hoop fitness class.

Dr James Harris

Chief Technology Officer

An experienced IT professional, James' prior work spans diverse environments from the white heat of launching information systems in one of the world's busiest airports, to industry leading tech startups. He also has extensive experience as a Finance Manager. James brings a keen insight and and flair for problem solving to every project.

Outside of work, James writes comedy, and has had many television credits over the past couple of decades on shows such as Horrible Histories and Russell Howard's Good News. He retains a burning ambition to be as funny as his wife and daughter.

Ph.D. Biochemical Physics, IT and Accounting professional.

Gwen Rymill

Communications Director

Co-founder of Smarter Business Processes, Gwen’s multi tasking roles include ensuring our clients receive the very best in customer care, while responsible for sales and marketing and partner liaison. Just don’t expect to get the cup of tea she promised you!

Away from work Gwen enjoys cycling, pilates, tap dancing and just loves baking.

Richard Rymill

CEO

Co-Founder and Lead Consultant, Richard set up SBP in response to worldwide demand from businesses wanting to implement their own Smarter Business Processes. His rapidly expanding team of experienced Smartsheet and AppSheet Consultants and Trainers share the company's values of achieving improved efficiencies and collaboration by putting people first and releasing them from unnecessary repetitive activities so they can enjoy their work again and focus on what matters to them.

When not at his desk, Richard can be found cycling, swimming and when the opportunity permits, sailing and flying.

Business Process
Automation Consultants

Smarter Dropdown List Manager – why did we create it? There are few things more satisfying in life than finding an easy solution to a time-consuming or repetitive task, particularly when it comes to business. Rather than focusing on the time saving ‘hacks’ that populate the internet and promise to help you squeeze the most from your day, we prefer to highlight our suite of Smarter Controls for Sheets. These are admin friendly apps which help Smartsheet users perform routine tasks more efficiently and reduce the possibility of human error when working across multiple sheets. Put simply? They make Smartsheet even smarter.

Steve Campbell, Jr from California Gold Development Corp says:

“We are loving the Smarter Dropdown List Manager…that one is a slam dunk and huge help to us. With all the sheets and workspaces, it is great for us to be able to use this to ensure we have consistent dropdown options across sheets. This helps ensure we have consistency and helps with reporting, etc
It is without a doubt a great feature for Smartsheet users. The more I think about it the more I wonder how other serious users of Smartsheet are managing without it”.

Streamline Dropdown List updates

Smarter Business Processes’ Smarter Dropdown List Manager is one of our Smarter Controls for Sheets apps, and a best-seller for good reason. It allows you to control dropdown list values from a central point, sending those values off to multiple dropdown lists across multiple sheets, thus creating a master dropdown list that automatically updates nominated columns across Smartsheet. To really streamline the updates, the master list can be created from a report that updates as sheets are updated and will push changes through to the nominated columns every 10 minutes, automatically and effortlessly.

Save time and ensure consistency in Smartsheet

As Smartsheet experts, we are constantly working to improve your business processes and overcome challenges. We knew that using Smartsheet to control several projects could be fiddly and time consuming, particularly when you need to update changing criteria that can impact several sheets, for example adding or removing staff members from dropdown options across multiple sheets.

Smarter Dropdown List Manager negates this issue by enabling you to send a single list of options to multiple dropdown lists in multiple different sheets all from one central point. You save valuable time, streamline lengthy updates, and maintain data uniformity by ensuring you’re updating your sheets once, rather than manually going into each one. You can even specify which sheets need to be updated, whether it’s individual sheets, an entire folder of sheets, or everything throughout an entire workspace. The app runs automatically every 10 minutes, hunts changes, and updates all connected Sheets. This alone can potentially save hours that was previously used to manually update dropdown options.

Russell Anderson, Head of Operations at Northern Transformer, says:

“We purchased the Smarter Dropdown List Manager and it has fixed one of the biggest deficiencies in Smartsheet. Since the first day I started using Smartsheet, I wanted something that would allow a dropdown list to be managed from another source. This tool does exactly that. It is clean, easily setup and has been very reliable. Now information flows seamlessly from our employee list to many other sheets where we use employee names in dropdowns. It eliminates many additional steps we used to have to do when changes to our employee list occured.
I have many other use cases queued up to take advantage of this capability. It has opened the door to enable many more smarter business processes!”

See more Client Testimonials or Case Studies

Configuring Smarter Dropdown List Manager is a User-friendly experience

Our apps are designed with users at heart. Smarter Dropdown List Manager can be managed entirely within Smartsheet and doesn’t require any coding. It runs with your existing IT environment meaning there is no disruption or additional manpower to implement it.

We have a host of satisfied clients who are discovering the many benefits to the Smarter Dropdown List Manager and our Smarter Controls for Sheets apps.

Are you ready to implement this time saving tool?Click here to view a demonstration video or book a discovery call to talk to us – Free Consultation & Trial Licenses – SmarterBusinessProcesses