We use cookies to ensure that we give you the best experience on our website.
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

By very popular demand from our clients and the Smartsheet Users Community

We are delighted to announce the launch of our Smarter Dropdown List Manager.

A solution for updating data values held in a master dropdown list which then automagically updates matching dropdown lists in other nominated Smartsheets



What are the pain points for Smartsheet users?

Manually updating the same dropdown list over multiple sheets, on a regular basis can be time consuming and open to human error, therefore not a reliable method of managing data

How does Smarter Dropdown List Manager relieve the pain?

Just one sheet that automagically updates all sheets that reference that list.


Why are Dropdown Lists so useful?

  • Values selected from a list of choices is considered to be structured data
  • Structured data ensures corporate consistency of data entry
  • Corporate consistency allows accurate data analysis which can make whole enterprise dashboards more meaningful
  • Dropdown list values can be used to trigger next actions in a workflow process, thus automating some manual work and improving efficiency
  • Dropdown Lists used in a Smart Form are ideal for capturing new data and ensuring consistent terminology from the end user environment. Dropdown lists within forms can also appear as Radio Buttons, for ease of selection

What is included in the Basic Package?

Setup:

    1. One Master Smartsheet Workspace with the capacity to:
      • Define up to 10 Dropdown Lists
      • Nominate up to 15 sheets that will reference each Dropdown List
      • Dropdown List sheets do not count towards your sheets allocation
    2. An Audit of your nominated sheets with recommendations on naming & consistency
    3. Implementation of Smarter Dropdown List Manager by our expert consultants
    4. Admin Training for taking control of Smarter Dropdown List Manager

NB Payments can be made by Direct Debit or Credit Cards. No Minimum period needed for this package. The feature will cease to work as soon as payment is stopped/missed. A maintenance / license fee ensures the system is maintained with Same day Support (or asap on Bank Holidays)

Are You ready for Smarter Dropdown List Manager?

Questions to ask yourself and colleagues in preparation for Smarter Dropdown List Manager:

  1. Do you use the same dropdown list columns across multiple sheets and do you need to update your dropdown list values in near real time for global dissemination?
  2. How many repeatable dropdown lists do you have & how often do you need to update your values?
  3. Do you have a corporate standard for dropdown list names and content? Or is this departmental?
  4. Would your dropdown list modifications be controlled by one administrator?  Or would you prefer an administrator for each department or country?
  5. Are you adding new sheets regularly? If so who will have the job to link-reference new sheets?

Do you…?

  • Need to discuss further API driven functionality with us not listed here?
  • Need to explore Smartsheet Workflows or linking your data across Apps automagically? (Available by integrating Appsheet with Smartsheet).
  • SBP offer bespoke consultancy – let’s arrange a meeting to discuss

I have tested this solution. It is easily set up with guidance from the SBP team. It works well and reliably does the job. I can see how this solution will be warmly welcomed by Smartsheet users at a cost which can easily be justified for many Smartsheet users. Tim Meeks

How to order Smarter Dropdown List Manager?

To find out more about this package or if this basic package is too small for your requirements:

  • Use this link to fill in an enquiry form:
Smarter Dropdown List Manager Enquiry

 

NB Due to high demand for this package, you need to keep to your setup consultant appointment as booked.  Appointments will be allocated on first come, first served basis and clients that miss appointments will be dropped to the bottom of the waiting list!