Smarter training adjusted to suit your real needs

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

Learn More

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

Smarter Business Processes is Cyber Certified

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 and AppSheet Consultant

David is an experienced Smartsheet 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 has worked for software companies as a Programmer and Test Analyst. He also has extensive experience as a Finance Manager. James brings an attention to detail 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.

Smarter Dropdown List Manager

Control your dropdown list column content centrally

Update values in a master dropdown list that automatically updates lists in other nominated Smartsheets. Need some of the lists to be filtered? No problem.

Smarter Dropdown List Manager, part of our suite of Smarter Controls 4 Sheets, helps Smartsheet users perform routine tasks more efficiently.

Our Smartsheet Dropdown List Manager will enable you to send a single list of options to multiple dropdown lists in multiple different sheets all from one central point for convenience and speed.

You will see how easy it is to streamline your updates, and how editable dropdown list entries can be.

How to update Dropdown Lists in Smartsheet with ease

Using Smartsheet to control a number of projects can be time consuming.

This is especially true when you need to update changing criteria such as project leaders that can impact several sheets.

It is now easier than ever to update Smartsheet from a single list of dropdown options, even when updating a multi sheet solution. 

Smarter Dropdown List Manager allows you to specify individual sheets to be updated, or all the sheets in a folder, and even throughout an entire workspace.  

The Smarter Dropdown List Manager app is one of our Smarter Controls 4 Sheets Apps.

dropdown list

Update dynamic dropdown lists with a single point of entry

Discover the convenience of managing all your list criteria from a single point with all your drop down lists values managed by using a single configuration sheet.

Save time with the Dropdown List Manager App

Learn how the dropdown list manager can save you the manual labour of managing your multiple dropdown lists, and find out how to keep them in sync automatically.

Ensure consistency by using the Dropdown List Manager

This App helps you to maintain data uniformity across multiple worksheets by ensuring all your sheets using drop down lists are updated from one central source.

FULLY CONFIGURABLE APP

  • Runs automatically every 10 minutes
  • Hunts changes
  • Then updates all connected Sheets
  • Update dropdown lists in multiple sheets.

ADVANCED FEATURES

Reports can also be a list source:

Filters can be used to select eg named workers on specific Projects.

USER-FRIENDLY

  • Can be managed entirely with Smartsheet
  • Runs within your existing IT environment
  • No coding needed
  • Paid for by annual subscription

What is the meaning of Drop-down list?

Drop down lists are useful items in information management. They are lists of items that appear whenever a piece of text or a button is clicked. When you run multilayered smart sheets the management of the drop down lists can become a challenge in itself because of the layering of information.

The reason dropdown lists are used in the first place is to organise the collection and selection of  important data and maintain consistency in that data.

What types of drop down columns are there?

There are two types of dropdown columns – single select columns and multiple select columns. When you use a single select dropdown list, you can only choose one item from the list of values, while using a multiple select dropdown column means that you can choose more than one value.

The value section contains information that will be displayed in your dropdown columns. A value can include punctuation symbols, letters, numbers, and emojis. They are organized based on any order of appearance that you specify when you enter them in the values list. NOTE – Keep in mind that if you insert an email address or a hyperlink in the value list, it will appear as plain text.