从现有列创建下拉列表
我有一个我们公司标准操作程序的数据库，我想有一个网络表单，允许我们所有的员工建议修改特定的SOP。我想我想从现有的列创建一个下拉列表，但它看起来像我必须分别输入它们来创建列表。也许还有别的解决办法?
评论
-
Richard Rymill，收缩压 ✭✭✭✭✭✭嗨，"数据女孩"这个名字有意思吧?
如果你有一个标准操作程序的标题列表，那么将它们作为下拉列表列出是没有问题的，只要将它们垂直排列，最好是按字母顺序排列，然后复制粘贴到下拉列表中。然后你的团队可以选择他们认为需要改进的SOP，并在下一个框中以叙述的方式告诉你他们希望如何改进它。
这种智能表单的使用非常有效。
如果你有不同的元素，请告诉我们是什么?
RichardR
-
数据的女孩 ✭
谢谢你，Richard!这当然很简单。
我做数据女孩已经有20年了
我审计农业科学研究，所以看起来很合适。
我审计农业科学研究，所以看起来很合适。类别
=COUNTIFS({Range}, @cell =<\/strong> [Job Number]@row)<\/p> Do you have any job numbers anywhere that do not have a leading zero?<\/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":106824,"type":"question","name":"pulling distinct data to another sheet","excerpt":"I have a worksheet which I am working metrics on a separate worksheet. I have a list of courses on the main sheet and they can be duplicates. What I am trying to do is pulling those distinct courses onto another worksheet and I can use count how many times they are used for, but I need to pull that distinct courses from a…","categoryID":322,"dateInserted":"2023-06-23T13:21:13+00:00","dateUpdated":null,"dateLastComment":"2023-06-23T13:54:22+00:00","insertUserID":160445,"insertUser":{"userID":160445,"name":"topazfae","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/topazfae","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxbJ3U64IGvX8bmfaqFsly2Ax_danmhhYKsfmMgQsQ=s96-c","dateLastActive":"2023-06-23T14:52:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-23T14:42:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":14,"score":null,"hot":3375055535,"url":"https:\/\/community.smartsheet.com\/discussion\/106824\/pulling-distinct-data-to-another-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106824\/pulling-distinct-data-to-another-sheet","format":"Rich","lastPost":{"discussionID":106824,"commentID":381960,"name":"Re: pulling distinct data to another sheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381960#Comment_381960","dateInserted":"2023-06-23T13:54:22+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-23T14:42:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-23T14:47:10+00:00","dateAnswered":"2023-06-23T13:54:22+00:00","acceptedAnswers":[{"commentID":381960,"body":" You would need a helper column on the metrics sheet (called \"Number\" in this example). You would manually enter the numbers 1 - whatever to cover the maximum number of possible unique classes. I also suggest a bit of a buffer just in case.<\/p> Then the formula to pull in the distinct list would be<\/p> =IFERROR(INDEX(DISTINCT({Course List}), Number@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":106788,"type":"question","name":"Using COUNTIFS Formula","excerpt":"Is there a way to use the COUNTIFS function (or another function) like the SUMIFS? I have this one working perfectly: =SUMIFS({OM Book Date}, {OM Total Sell}, AND(@cell >= DATE(2023, 6, 1), @cell <= DATE(2023, 6, 30))) Now I need it to count OM Total Sell (some are blank, I need it to count only the ones that have numbers…","categoryID":322,"dateInserted":"2023-06-22T16:52:09+00:00","dateUpdated":"2023-06-22T16:58:39+00:00","dateLastComment":"2023-06-23T13:58:05+00:00","insertUserID":162642,"insertUser":{"userID":162642,"name":"jtomeaCH","title":"ISG Support Manager","url":"https:\/\/community.smartsheet.com\/profile\/jtomeaCH","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T13:53:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-23T14:42:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":45,"score":null,"hot":3374985614,"url":"https:\/\/community.smartsheet.com\/discussion\/106788\/using-countifs-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106788\/using-countifs-formula","format":"Rich","lastPost":{"discussionID":106788,"commentID":381963,"name":"Re: Using COUNTIFS Formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381963#Comment_381963","dateInserted":"2023-06-23T13:58:05+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-23T14:42:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-23T13:53:39+00:00","dateAnswered":"2023-06-23T12:53:15+00:00","acceptedAnswers":[{"commentID":381926,"body":" It looks like you may need a COUNT\/DISTINCT\/COLLECT combo then.<\/p> =COUNT(DISTINCT(COLLECT({Work Order}, {Book Date}, AND(IFERROR(MONTH(@cell), 0) = 6, IFERROR(YEAR(@cell), 0) = 2023)))<\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
<\/p>
<\/p>
<\/p>
