Have Us: Call You Back

Call Us: UK: +44 1937 541 553

Email Us: info@smarterbusinessprocesses.com

Other Options: Contact Us

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, 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.

Smarter Sheet Manager Commands List

Our powerful tool for System Administrators includes a number of Commands enabling you to make complex changes to multiple Smartsheet sheets in one run, saving you valuable time and protecting data integrity.

Smarter Sheet Manager works by selecting a Command then adding either one parameter {X} or two parameters {X} and {Y} as required.

Example 1 – if you selected Command “Add Column {X}” you would use the {X} parameter to enter the new column name.

Example 2 – if you selected Command “Add Column {X} before column {Y}” you would use the {X} parameter to enter the new column name and the {Y} parameter to name the existing column to the left of which the new column would be added.

The following gives additional information about each of the Commands:

COLUMNS FUNCTIONS

Add Column {X}

Add a new column named X
{X} = name of new column 

Add Column {X} before column {Y}

Add a new column named X before existing column Y
{X} = name of new column, {Y} = existing column name. New column will be inserted to the LEFT of the existing column

Add Column {X} after column {Y}

Add a new column named X after existing column Y
{X} = name of new column, {Y} = existing column name. New column will be inserted to the RIGHT of the existing column

Add Column {X} at index {Y}

Add a new column named X at location Y
{X} = name of new column, {Y} = number (integer) of the required location where 0 is the far left of the sheet

Move Column {X} before column {Y}

Move column X to the LEFT of column Y
{X} = name of column to be moved, {Y} = name of column to the LEFT of which column {X} will be moved

Move Column {X} after column {Y}

Move column X to the RIGHT of column Y
{X} = name of column to be moved, {Y} = name of column to the RIGHT of which column {X} will be moved

Move Column {X} to index {Y}

Move column X to the LEFT of column Y
{X} = name of column to be moved, {Y} = number (integer) of the required location where 0 is the far left of the sheet

Set Column {X} with description {Y}

Add a column description Y to column X
{X} = target column name, {Y} = the required column description text

Change Column to Text/Number

Change the type of column X to Text/Number
{X} = name of column to change

Change Column to Date

Change the type of column X to Date
{X} = name of column to change

Change Column to Checkbox

Change the type of column X to Checkbox
{X} = name of column to change

Change Column to Single Picklist

Change the type of column X to Single Picklist (single select Dropdown List)
{X} = name of column to change

Change Column to Multi Picklist

Change the type of column X to Multi Picklist (multiple select Dropdown List)
{X} = name of column to change

Change Column to Single Contact List

Change the type of column X to Single Contact List
{X} = name of column to change

Change Column to Multi Contact List

Change the type of column X to Multi Contact List
{X} = name of column to change

Rename Column {X} to {Y}

Rename column X to Y
{X} = name of column to change, {Y} = new column name

Show Column {X}

Unhide Column X
{X} = name of column to unhide

Hide Column {X}

Hide Column X
{X} = name of column to hide

Lock Column {X}

Lock Column X
{X} = name of column to lock

Unlock Column {X}

Unlock Column X
{X} = name of column to unlock

Delete Column {X}

Delete Column X
{X} = name of column to delete

SHEET SUMMARY FIELD FUNCTIONS

Add Summary Field {X}

Add a new Sheet Summary field named X
{X} = name of new Sheet Summary field

Add Summary Field {X} before field {Y}

Add a new Sheet Summary field named X ABOVE Summary field Y
{X} = name of new Sheet Summary field, {Y} = Existing Sheet Summary field ABOVE which the new field will be inserted

Add Summary Field {X} after field {Y}

Add a new Sheet Summary field named X BELOW Summary field Y
{X} = name of new Sheet Summary field, {Y} = Existing Sheet Summary field BELOW which the new field will be inserted

Change Summary Field {X} to Text

Change the type of Sheet Summary field X to Text/Numbe
{X} = name of Sheet Summary field to change

Change Summary Field {X} to Contact List

Change the type of Sheet Summary field X to Contact List
{X} = name of Sheet Summary field to change

Change Summary Field {X} to Date

Change the type of Sheet Summary field X to Date
{X} = name of Sheet Summary field to change

Change Summary Field {X} to Dropdown

Change the type of Sheet Summary field X to Dropdown (Single Select)
{X} = name of Sheet Summary field to change

Change Summary Field {X} to Checkbox

Change the type of Sheet Summary field X to Checkbox
{X} = name of Sheet Summary field to change

Change Summary Field {X} to Symbol Flag

Change the type of Sheet Summary field X to Symbol (Flag)
{X} = name of Sheet Summary field to change

Change Summary Field {X} to Symbol Star

Change the type of Sheet Summary field X to Symbol (Star)
{X} = name of Sheet Summary field to change

Delete Summary Field {X}

Delete Sheet Summary field X
{X} = name of Sheet Summary field to delete

COLUMN FORMULA FUNCTIONS

Set Column {X} with formula {Y}

Add a column formula Y to column X
{X} = target column name, {Y} = the required column formula

Convert All Columns Formulas to Result

Convert all cells in the sheet calculated by Column Formulas to their current values and remove Column Formula

Convert Column {X} Formula to Result

Convert all cells in column X calculated by Column Formulas to their current values and remove Column Formula
{X} = name of column to convert

Convert Column {X} Description Formula to Result

FORMATTING FUNCTIONS

Set Column {X} with Background color {Y}

Change the background of column X to the colour specified in Y
{X} = name of target column, {Y} = required colour specified as a HEX value, eg #FF0000

Set Column {X} with Font color {Y}

Change the text of column X to the colour specified in Y
{X} = name of target column, {Y} = required colour specified as a HEX value, eg #FF0000

CROSS SHEET REFERENCE FUNCTIONS

Add Cross Sheet Reference {X}

Create a new Cross Sheet Reference in each Sheet to the specified range within the specified sheet IDThis requires a special format where a formula is entered into column
{X} as follows

{“Name”:”xxx”,”SourceSheetId”:xxx,”StartColumnName”:”xxx”,”EndColumnName”:”xxx”}

Name = Name of the new Cross Sheet Reference
SourceSheetID = Sheet ID of the referenced sheetStart
ColumnName = Name of column that STARTS the range
EndColumnName = Name of column that ENDS the range

NOTE where a SINGLE column is required as the range, specify this column for both StartColumnName and EndColumnName

Smarter Sheet Manager App
See Other Apps
More Information? Pricing?