Dependant dropdown lists
Hi. Is it possible to create a dorpdown list that is dependent on the option selected in other column. For example, when I have list of 300 Banks with SWIFT codes . One column is Bank name, another column is SWIFT code. I also have a list of vendors and need to choose in vendor form their bank account. I write vendor name in column A , select "Bank" in column B, and i need a SWIFT code automaticaly appear in column C according to information from banks list. This is simple task for Sharepoint. What about Smartsheet?
Comments
-
Paul Newcome ✭✭✭✭✭✭Can you provide some screenshots (with dummy data of course)? That may help with a solution.
thinkspi.com
-
No idea, but following as I wish to do similar with Departments and Staff sorting.
Select the department in one list and then have a populated list that identifies the people in that group. -
DIV ✭
I am astonished that this service does not have these features. I
can not imagine in which business tasks i can use smartsheets without linked lists.
Meeting room scheduling? Vocation requests?
-
Andrée Starå ✭✭✭✭✭✭Hi All,
Please submit an Enhancement Request when you have a moment.
A New Way to Submit Your Feature Requests
To make your Enhancement / Feature Request count, send in the form above because there isn’t a guarantee, it will be registered otherwise.
Original Post:https://community.smartsheet.com/announcement/new-way-submit-your-feature-requests
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
-
Paul Grim ✭✭✭✭✭
I agree this is a sorely lacking feature, and I've submitted my own enhancement request for it. Fingers crossed!
Smartsheet Certified Product User
-
Joachim Mund ✭✭✭✭✭✭
This will work with appsheet based on smartsheet
-
MariaCurtis ✭✭
@Paul GrimI know this is an older post, but can you share your link to the enhancement request you posted on this topic?
-
Genevieve P. Employee AdminYou can check out other enhancement requests and ideas from theProduct Feedback and Ideastopic here in the Community! Feel free to vote on current ideas, create a new idea, and jump into a thread to add your own context for a request:
Cheers,
Genevieve
Categories
Perfect. Thank you so much!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":106958,"type":"question","name":"Datamesh very slow to update","excerpt":"Hi, we have datamesh set to immediate but it still takes up to a minute for the data to be pulled into the sheet. Is this the normal amount of time it's supposed to take? Or have I missed a trick?","snippet":"Hi, we have datamesh set to immediate but it still takes up to a minute for the data to be pulled into the sheet. Is this the normal amount of time it's supposed to take? Or have…","categoryID":321,"dateInserted":"2023-06-27T15:05:03+00:00","dateUpdated":null,"dateLastComment":"2023-06-27T21:09:27+00:00","insertUserID":161700,"insertUser":{"userID":161700,"name":"Jagdeep","url":"https:\/\/community.smartsheet.com\/profile\/Jagdeep","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T21:01:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":15741,"lastUser":{"userID":15741,"name":"ker9","url":"https:\/\/community.smartsheet.com\/profile\/ker9","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T21:07:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":28,"score":null,"hot":3375780270,"url":"https:\/\/community.smartsheet.com\/discussion\/106958\/datamesh-very-slow-to-update","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106958\/datamesh-very-slow-to-update","format":"Rich","tagIDs":[219,334,381],"lastPost":{"discussionID":106958,"commentID":382703,"name":"Re: Datamesh very slow to update","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382703#Comment_382703","dateInserted":"2023-06-27T21:09:27+00:00","insertUserID":15741,"insertUser":{"userID":15741,"name":"ker9","url":"https:\/\/community.smartsheet.com\/profile\/ker9","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T21:07:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-27T21:04:31+00:00","dateAnswered":"2023-06-27T19:57:59+00:00","acceptedAnswers":[{"commentID":382687,"body":"
