Centrally controlling column content!
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
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.