I am creating numerous sheets for different reportfunctions in our store network. Each sheet will have the same set of stores in the Location column. Can I create one list and use it for every sheet?
Hi @Diane Nelligan
Unfortunately no, (certainly not yet), I have requested this on a feature request though. It would be brilliant if you could reference a single sheet each time for a specific dropdown list.
The option is to use the data uploader so that when you add a location, you can set up an schedule to update look for changes in the sheet with the column of information called Locations and then it updates the location in every sheet that you tell it to.
You only need to set it up once and then make sure you add the new sheet to it for uploading. When you update the main sheet with location and you trigger the update (or schedule it), it finds the sheet, the field with the drop down information and then updates the list.
It doesn't work for contact list items unfortunately but it does for everything else.
Hope that helps
Your Time is Important, you want to Stay on Track, We can help you use the Right Tools
Good day. Is the universal dropdown function available yet?
I am running in circles trying to solve this issue - seemingly, in using MATCH() on an external cell reference, the value it returns caps itself at 14 even though data goes out to ~30. While I end up using this base function in much larger equations, the screenshots explain the basis of the issue: Here is the Cell…
Hello, I am currently attempting to organize my files in Workspace by creating folders to group them. I am doing this by dragging and dropping sheets from the 'Sheets' folder into my 'Workspace' folder. However, some sheets that I own and created do not appear in the 'Sheets' folder. I even tried editing some details in my…
The number of Unlicensed Users was listed previously under User Accounts. Why is it no longer there?
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.