Smarter Dropdown List Manager – Content Collector

Centrally controlling column content!

At SBP we monitor the Smartsheet community and have been seeing this question and questions like it repeatedly. We are delighted to announce the answer is here!

Smarter Dropdown List Manager – Content Collector

Part of our Smarter Apps Platform which provides the solution for collecting data values held in another sheet or across multiple sheets delivered to a designated destination dropdown list!

What are the pain points?

  • We want dropdown lists to be kept up-to-date with offerings, but currently have to manage the data manually, this is time consuming and open to error/omission

  • I need to remember exact data values to drive statistics sheets

  • Smartsheet is not a relational database, but increasingly we need to use our sheets in a relational way

How does Smarter Dropdown List Manager – Content Collector help?

Within Smarter Dropdown List Manager – Content Collector all your dropdown lists’ values can be managed using a configuration sheet. Within the configuration sheet, you can control how a destination dropdown list is fed its data from other columns in the same sheet, from columns in other sheets; you can even have data from multiple columns and multiple sheets feeding just ONE List! The applications for this feature are endless! If you combine this feature with a Vlookup function, you could facilitate relationships between your sheets! Finally, a way of relating your data!

Smarter Dropdown List Manager – Content Collector – Seamless, effortless and extremely efficient.

Dropdown List Manager Options

Smarter Dropdown List Manager

Smarter Dropdown List Manager – One to Many

 

Can’t see the document below ? click here to refresh or Download a copy here