Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.
Linking sheets through dropdown box
Is it possible to create a dropdown box which draws it's items from the primary column of another sheet? I am putting together a system for managing the data related to my staff members including workplans, professional development and reporting. On each sheet I would like to be able to ask the staff member to choose their name from a dropdown box. this list of names needs to be drawn from a master sheet, so that if I add a new staff member on the master it automatically appears on the other lists. This is only one way I which I would like to be able to link different sheets with this functionality across a broad range of topics.
它可以完成了,如果是这样,何w?
Comments
-
Atus Bartal ✭✭✭✭✭✭Dear Beryl,
Unfortunately: NO.
I and many others are waiting eagerly to use a functionality in Smartsheet like this.
See also (and in many related discussions):https://community.smartsheet.com/discussion/drop-down-list-data-column-another-sheet
Some quotes:
"must have feature"
"... would prevent me from buying database software"
"otherwise Smartsheet is just a toy"
"a large number of users would benefit from"
Travis wrote on May 4, 2015: "Dynamic lists isn’t something we are currently working on but we are tracking feedback for this request and I will pass this thread along to our product team!" - I do hope the product team has been very active meanwhile not only in tracking users' feedback but also in code writing... Scanning through the Community discussions, I can hardly see another feature the folks are waiting so much. It would make Smartsheet a good alternative to database softwares.
I hope someday we'll have it...
Atus
-
Travis Employee水苍玉,As Atus pointed out, there is not a built in way to link a Dropdown List to a column in another sheet but this is possible with a third party app -Azuqua.
You mentioned you want to have new staff members automatically added to your Dropdown Lists so they can select their names. Have you considered using Contact List columns instead?
Contact lists will auto-resolve user's names based on, who is assigned to tasks in the sheet, who is shared to the sheet, who is in your Smartsheet Contacts, and who is a member of your team.
If you add the new staff member to your team, then they will just need to start typing their name in the Contact List cell and Smartsheet will auto-resolve their information.
You can then use the Contact List for things like Resource Management, Reporting, and Reminders.
-
J. Craig Williams ✭✭✭✭✭✭水苍玉,
As Travis mentioned, this is possible in Azuqua.
If you'd like a demo, contact Richard at
Tell him Craig sent you.
Craig
-
Knowing that Azuqua can do it, I'm still requesting (or vote for) the ability, directly in Smartsheet, to create dropdown lists dynamically from a column on a different sheet. Furthermore, I wish for this ability to have a filter. For example, in my timesheet, the Project column is a Dropdown list of all projects (from my master projects sheet) that have a Status of "Open".
Without having to re-create filters directly functionality when you define the dropdown, you could just add the ability to use an existing filter from the "master" sheet.
Without filters, this ability is still useful, though not as much. So please consider filters as well when you consider this functionality.
-
Two years later. Is this feature still missing from Smartsheet?
-
Think so. It looks quite achievable with the API and I will try to develop a solution myself. If I am successful I'll share it with you.
-
J. Craig Williams ✭✭✭✭✭✭
Which SDK do you intend to use?
Craig
-
JeremiahHorstick ✭✭✭✭✭✭Travis,
I built www.ddupdate.com to do exactly this.
Have you checked it out?
-J
-
Jose Munoz ✭✭Can you do Dynamic combo dropdown list with DDUpdate? I bought the monthly plan to test and I can only make and keep the list for 1 dropdown not combo
-
Jose Munoz ✭✭
Apparenlty, very unfortunate
-
JeremiahHorstick ✭✭✭✭✭✭
No. Functionality for Dynamic or Nested Dropdowns is not currently supported.
Andréementioned this functionality being released by Smartsheet. Is that so?
-
JeremiahHorstick ✭✭✭✭✭✭
Jack,
下拉选项指定列的水平。To create dropdown options based on the selection of a prior option, this would require being able to set the options on the row level, which is not supported by the API.
-J
Categories
I figured it out! Updated formula to get the 2 decimal places as well.<\/p>
=\"We are at \" + IFERROR(ROUND([% closed rate]@row * 100, 2), \"//www.santa-greenland.com/community/discussion/4292/\") + \"% closed rate on ticket status for the month of \" + Month@row<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":108861,"type":"question","name":"IF\/AND Formula","excerpt":"Formulas are the bane of my existence and I really need to take a class! Today I'm trying to set up a formula to throw a flag when 2 conditions are met. I want a red ball when I have not received an invoice and the invoice due date is within 30 days. I know I'm close since I've gone from \"unparsable\" to \"incorrect…","snippet":"Formulas are the bane of my existence and I really need to take a class! Today I'm trying to set up a formula to throw a flag when 2 conditions are met. I want a red ball when I…","categoryID":322,"dateInserted":"2023-08-11T16:27:44+00:00","dateUpdated":null,"dateLastComment":"2023-08-11T17:49:45+00:00","insertUserID":120231,"insertUser":{"userID":120231,"name":"Pamela Wagner","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Pamela%20Wagner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-11T17:47:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":120231,"lastUser":{"userID":120231,"name":"Pamela Wagner","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Pamela%20Wagner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-11T17:47:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":47,"score":null,"hot":3383549849,"url":"https:\/\/community.smartsheet.com\/discussion\/108861\/if-and-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108861\/if-and-formula","format":"Rich","lastPost":{"discussionID":108861,"commentID":390268,"name":"Re: IF\/AND Formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/390268#Comment_390268","dateInserted":"2023-08-11T17:49:45+00:00","insertUserID":120231,"insertUser":{"userID":120231,"name":"Pamela Wagner","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Pamela%20Wagner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-11T17:47:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-11T17:48:48+00:00","dateAnswered":"2023-08-11T17:12:43+00:00","acceptedAnswers":[{"commentID":390261,"body":"
You were, indeed, very close.<\/p>
=IF([Invoice Received?]@row = 0, IF(AND([Renewal Date]@row >= TODAY(), [Renewal Date]@row <= TODAY(+30)), \"Red\"))<\/p>"},{"commentID":390264,"body":"
