在一个大的下拉列表中搜索
你好,
我现在有一份我们公司信用卡的费用报告。在费用报告上，我有一个下拉列表，列出了所有的帐户号码，以便每个行项目都可以提交到正确的帐户。有数百个帐户，我想知道是否有办法扩大搜索内的下拉。我知道，如果你开始键入帐户名称，它将弹出，但如果你没有具体的名称和帐户名称的前几个字母，它将不显示任何值。例如，旅游-机票。如果你开始输入“旅行”，这个账户就会弹出，但如果有人只输入“机票”，这个账户就不会显示出来。是否有一种方法可以让Smartsheet在下拉列表中搜索所有单词和数字，而不仅仅是每个选项的开始。这将有助于新手搜索账户，并将消除浪费在搜索账号上的时间。
谢谢你！
评论
-
保罗新来的 ✭✭✭✭✭✭目前还没有在下拉菜单中搜索的方法。
但是，您可以打开列详细信息，就像要添加一个新值一样，复制所有值，将它们粘贴到工作表的其他位置或不同的“引用”或“查找”工作表上。然后，您可以在那里搜索以找到正确帐户的确切名称/编号，并从那里开始将值输入(甚至复制/粘贴)到您想要记录它的单元格中。
如果总是对以标准格式输入的相同行项使用相同的帐户，则可以构建一个表，并使用INDEX/MATCH或VLOOKUP函数根据行项中的文本自动填充帐户编号。
thinkspi.com
-
她名叫Stara ✭✭✭✭✭✭你好,
下面是一个变通方法，它使您可以使用信息列表，并从列表中进行选择(不适用于移动设备，仅适用于桌面)。
也可以在链接表中搜索找到账号。
我正在利用细胞连接来解决这个问题。主工作表链接到下拉表/列表工作表。
更多信息请见附件链接/截图。
希望这对你有帮助!
最好的
她名叫Stara
工作流程顾问@完成咨询
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
-
EFG16 ✭
你好,
我看到这个问题在2018年得到了回答;这个问题是否已经解决或添加为一个选项?
类别
Apply a filter to the sheet and then you can select that filter in the Dynamic View.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":106193,"type":"question","name":"Multiple Forms, One Smartsheet","excerpt":"I created two identical forms (except for the name) and both of them populated into the same smartsheet. Is there a way to only see one form's submissions?","categoryID":321,"dateInserted":"2023-06-08T13:28:04+00:00","dateUpdated":null,"dateLastComment":"2023-06-08T13:47:26+00:00","insertUserID":152102,"insertUser":{"userID":152102,"name":"AllieB","url":"https:\/\/community.smartsheet.com\/profile\/AllieB","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T13:49:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":66106,"lastUser":{"userID":66106,"name":"Peggy Parchert","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Peggy%20Parchert","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/YYRDMWWFX83G\/nC7HLGW82ACPT.jpg","dateLastActive":"2023-06-08T22:09:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":47,"score":null,"hot":3372467730,"url":"https:\/\/community.smartsheet.com\/discussion\/106193\/multiple-forms-one-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106193\/multiple-forms-one-smartsheet","format":"Rich","lastPost":{"discussionID":106193,"commentID":379551,"name":"Re: Multiple Forms, One Smartsheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379551#Comment_379551","dateInserted":"2023-06-08T13:47:26+00:00","insertUserID":66106,"insertUser":{"userID":66106,"name":"Peggy Parchert","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Peggy%20Parchert","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/YYRDMWWFX83G\/nC7HLGW82ACPT.jpg","dateLastActive":"2023-06-08T22:09:49+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-08T13:46:06+00:00","dateAnswered":"2023-06-08T13:44:25+00:00","acceptedAnswers":[{"commentID":379548,"body":"
