Audit and Manage Data Structure and Content en masse.
Part of our Front end Platform, which sees SmarterControls4Smartsheet at the core, Smarter Data Manager provides an editable view of any of your datatypes from ALL your sheets to enable you to manage data globally.
This incredible feature has been developed for managing Dropdown List datatypes across your organisation. But in seeing the valuable impact this feature has had on managing dropdown list datatypes, SBP have decided to expand the feature and include ALL datatypes!
What does Smarter Data Manager give you?
A view across all your sheets (accessible via your Smartsheet API Access Token)
The ability to search on Workspace; Folder; Sheet; Datatype OR Value, followed by further drill down method to get down to the data you need to manage
- An edit link with an update feature allowing you to change data structure (column names) or the content of columns en masse
- A fast, accurate and effective way of auditing your data
Why would I need this?
If an employee leaves your organisation and a new starter takes over their role, you can find all tasks assigned to the leaver across all project and task sheets and update the assigned to value to the new starter!
If you decide to re-name a product or service, you can find all entries for the old name and update them across ALL sheets to the new name!
You can use this to determine the dropdown values you’d like in each dropdown list!
If you are not sure which project sheet contains a specific task, you could search for the task’s value using Smarter Data Manager and it would return the sheet, folder and workspace that the value is present in!
Think of the benefits of using Smarter Data Manager!
- How much time could you save by finding and replacing values across all sheets in 1 go?
- Eradicate typos quickly and effectively leaving you with a CLEAN data sheet providing accurate reporting
- So many more benefits, too many to list here!
Smarter Data Manager – Seamless, effortless and extremely efficient.