Work Smarter – more efficiently – with one of our ‘Off the shelf’ App Solutions.

We have designed a suite of Standard Apps and Solutions that cover common business requirements and which are unrivalled in ease of use, flexibility and price.

Take a look for yourself:

• SmarterControls4sheets
• Smarter Dropdown List Manager
• Smarter Formula Loader
• Smarter Workflow Manager
• Smarter Data Manager
• Smarter Column Naming
• Smarter Backups
• Smarter Permission Explorer
• Smarter Project Initialiser
• Smarter Cell-Level Timestamp Manager
• Smarter Excel Integration
• Smarter Accounting

Review our range of Smarter Apps or let us help you implement Smartsheet’s own Add-ons and Accelerators

Turn your spreadsheets (Excel, Google Sheets, Smartsheets)  into a relational database using mobile apps

Mobile Apps are more important than ever for businesses striving to engage with their consumers, employees, operations and suppliers using virtually any device. 

Using your existing sheets, workflow and logic, we can help you build a mobile app that combines data between your sheets at a fraction of the cost of traditional mobile app development.  

Arrange your Free Initial Consultation to review your Team App requirements OR if you have ideas to develop a more bespoke Mobile App solution, please complete our detailed needs appraisal – We’re here to help

The post Smarter Applications appeared first on SmarterBusinessProcesses.

When we’re developing our Smarter Apps we pay close attention to what the Smartsheet Community needs.

And our Smarter Dropdown List Manager is no exception.

5 Reasons to use Smarter Dropdown List Manager

Here’s 5 reason why Smarter Dropdown List Manager remains our most popular product year after year…  

1. Time Saving. Smarter Dropdown List Manager allows you to send a single list of options to multiple drop down lists and multiple sheets from one central point. You can specify individual sheets, or all of them, saving you time and energy.  

2.  Automation. Whether you are managing one project or one hundred, Smarter Dropdown List Manager gives you full control of your dropdown lists from one central point. Update the assigned to column on one sheet, and it will automatically update as many sheets as you need, without having to go into each sheet and manually make the changes. 

3. Manual Refresh. Normally the SDLM will update every ten minutes or so. But you can refresh manually any time you need by clicking on the manual refresh button on your Smarter Controls for Smartsheet console. 

4. Flexibility and Control. Use the Control Sheet to specify the source sheet and tell the system which column to use as the source data. Your destination sheet can represent an entire folder or workspace, giving you even greater control over your sheets.

5. SDLM is just the beginning. Our consultants can design and implement a range of enhancements to Smartsheet for less than you might think. Our support packages are tailored to your needs and support can be used in a range of ways to suit you.

Video demonstration of Smarter Dropdown List Manager

Watch our latest demo video from Smartsheet consultant David Bower below.

Alternatively, for more information contact us to arrange a free consultation today.

The post Smarter Dropdown List Manager: Why We Love It appeared first on SmarterBusinessProcesses.

The Challenge

• kW Efficiency needed to be able to pull drop down data from their Project Tracker, Sample Tracker, Change Order Tracker, and Warranty Tracker “Active Projects” column to create a comprehensive drop down list of all of our “Active Projects”
• They needed to Archive Rows by moving a row of data from the “Main Active Sheet” to a new row in the “Archive Sheet”
• They also needed to be able to use index and match to source contacts from the source data sheet, example: Project Tracker, Customer contacts. Contacts are a unique value that carry with them the ability to sort reports by current user.  The problem was that you cannot write a formula in a Contact column cell.

The Solution

A selection of Apps from SmarterControls4Smartsheet, namely;

• SDLM Content Collector
• Smarter Workflow Manager
• Smarter Formula (results) Loader

The Benefits

• Automated Merging of multiple sources into single-list [master] into multiple, synchronized drop down lists
• Automated movement of records to an archive sheet based on the trigger value in a specified column
• By using the formula adder, we are be able to use a helper column next to the destination column in the destination sheet to write the formula and then have the contact appear in the contact column next to it.

Testimonial

We had a fantastic experience collaborating with Smarter Business Processes and their Smarter Applications, we are now able to work much more efficiently and with more reliable data.

We had a vision of using 1 primary software platform to run the processes of the company through.  Smartsheet offered the foundation to build the platform in almost every way but there were some additional high level programing features that we required in order to bring it all together.

Jacques Guitard took the time to listen to our needs to fully understand what needed done.  The pricing was fair and the development time was quick from concept to beta, to revisions, to final product.  Jacques and Etienne  were quick to respond to ideas, questions, and troubleshooting.

I couldn’t be happier with the results and with the interactions from beginning to present.  Matt Jones – Operations Manager – KW Efficiency

The post SmarterControls4Sheets turbocharges Smartsheet for lighting retrofit company appeared first on SmarterBusinessProcesses.

Read More

The post Smarter Dropdown List Manager for Smartsheet – Manage Change at Scale appeared first on SmarterBusinessProcesses.

These Apps stretch the functionality of Smartsheet and Appsheet to create some amazing new, low cost business automations and App Integrations.  Leading the launch is their much requested Smarter Dropdown List Manager solution.

As one of Smartsheet’s leading Consultants operating across North America, UK and Europe, Smarter Business Processes have shadowed Smartsheet’s phenomenal growth, with their own client base doubling year on year.

Since Listing on the Nasdaq Smartsheet Shares (SMAR) have doubled from $15 USD to @ $30 USD and the business and Investing world is watching and finding out what it is that is hot about Smartsheet.

SBP CEO Richard Rymill said;  Organisations are seeking more  Automation and App Integration. So using the latest Smartsheet APIs enables us to stretch the standard solution to achieve things which many ERP systems would love to do, providing real Time Dashboards and collaborative solutions previously not possible.”

Speaking at a time of great change in both the world and the workplace Smarter Business Processes CEO Richard Rymill had this advice for organisations; “Embrace the opportunities presented to gain competitive advantage.  Invest in your people and within your own workforce generate a culture of continuous innovation.  Your people will love it if you do it well!”

The post Smartsheet crosses the pond from Boston USA to Boston Spa UK appeared first on SmarterBusinessProcesses.