欢迎来到Smartsheet论坛档案


在这个论坛的帖子不再被监控的准确性和他们的内容可能不再是最新的。如果这里有你感兴趣的讨论，你想找到(或创建)一个更最新的版本，请访问当前论坛。

下拉问题的形式

迈克·厄克特
迈克·厄克特 ✭
编辑12/09/19 在2017年发布的文章

试着建立一个客户反馈表格。

不知道为什么，但窗体不保存下拉框，因为我已经进入他们。

我像这样输入并保存它

5 -非常满意

4 -满意

3 -中性

2 -不满意

1 -非常不满意

当我打开表单时，它看起来是这样的

1 -非常不满意

5 -非常满意

4 -满意

3 -中性

2 -不满意

我已经关闭，重新打开和重做这个多极时间与相同的结果....

任何帮助，感谢，我做错了什么?

标签:
· 在Facebook上分享 在Twitter上分享

评论

这次讨论已经结束了。

类别

Hi @ker9<\/a> <\/p>

That limit is specific to bulk-uploading the emails into the group, to ensure that the request is processed successfully. I don't believe there's currently a hard limit for the number of users that can be in a group. I have seen some groups with around 10,000 contacts, if that helps. <\/p>

Cheers,<\/p>

Genevieve<\/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":[{"tagID":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"}]},{"discussionID":106588,"type":"question","name":"If formula with several criteria","excerpt":"Hi, I was working on a formula last week, but I am still struggling with a second criteria on this. the way its set up, updating the field depending on dates being input into others. this works well as follows; =IFERROR(IF([Client review Required]@row = \"Yes\", IF([Actual Submit Date]@row = \"//www.santa-greenland.com/community/discussion/7452/\", \"Pending\", (IF([Actual…","categoryID":322,"dateInserted":"2023-06-19T07:17:16+00:00","dateUpdated":"2023-06-19T07:50:51+00:00","dateLastComment":"2023-06-20T07:35:16+00:00","insertUserID":161866,"insertUser":{"userID":161866,"name":"Kirsteen Leckie","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Kirsteen%20Leckie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-20T07:32:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":161866,"lastUser":{"userID":161866,"name":"Kirsteen Leckie","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Kirsteen%20Leckie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-20T07:32:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":62,"score":null,"hot":3374408552,"url":"https:\/\/community.smartsheet.com\/discussion\/106588\/if-formula-with-several-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106588\/if-formula-with-several-criteria","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106588,"commentID":381239,"name":"Re: If formula with several criteria","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381239#Comment_381239","dateInserted":"2023-06-20T07:35:16+00:00","insertUserID":161866,"insertUser":{"userID":161866,"name":"Kirsteen Leckie","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Kirsteen%20Leckie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-20T07:32:56+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-20T07:33:41+00:00","dateAnswered":"2023-06-20T04:25:04+00:00","acceptedAnswers":[{"commentID":381236,"body":"

@Kirsteen Leckie<\/a> <\/p>

I made some tweaks to the formula, please try below<\/p>

=IF([Client review Required]@row = \"Yes\", IF([Actual Submit Date]@row = \"//www.santa-greenland.com/community/discussion/7452/\", \"Pending\", (IF([Actual Compete date]@row = \"//www.santa-greenland.com/community/discussion/7452/\", \"Internal Review\", (IF([Actual Date to Client]@row = \"//www.santa-greenland.com/community/discussion/7452/\", \"Send To Client\", (IF([Actual Client comments]@row = \"//www.santa-greenland.com/community/discussion/7452/\", \"Client Review\", (IF([Actual Piramal Response]@row = \"//www.santa-greenland.com/community/discussion/7452/\", \"Addressing Comments\", (IF([Actual Final Client Approval]@row = \"//www.santa-greenland.com/community/discussion/7452/\", \"Client Approval\", (IF([Actual submission to QA]@row = \"//www.santa-greenland.com/community/discussion/7452/\", \"QA Review\", (IF([Actual Final or QA Approval]@row = \"//www.santa-greenland.com/community/discussion/7452/\", \"QA Review\", \"Approved\"))))))))))))))), IF([Client review Required]@row = \"No\", IF([Actual Final or QA Approval]@row = \"//www.santa-greenland.com/community/discussion/7452/\", \"QA Review\", \"Approved\")))\n<\/pre>"}]}},"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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":106601,"type":"question","name":"Please can someone help with this formula","excerpt":"I am trying to calculate how many \"qualification\" stages there are in a given fiscal period for example Q4-2023, I know I am missing something but every variation of Count if formulas I have tried do not seem to work, it will be something really simple, that I am trying to make to complicated, but any help will be…","categoryID":322,"dateInserted":"2023-06-19T15:46:15+00:00","dateUpdated":"2023-06-19T15:48:22+00:00","dateLastComment":"2023-06-19T15:54:15+00:00","insertUserID":150472,"insertUser":{"userID":150472,"name":"Mel C","url":"https:\/\/community.smartsheet.com\/profile\/Mel%20C","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T18:04:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":150472,"lastUserID":144360,"lastUser":{"userID":144360,"name":"Hollie Green","url":"https:\/\/community.smartsheet.com\/profile\/Hollie%20Green","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T22:11:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":28,"score":null,"hot":3374380230,"url":"https:\/\/community.smartsheet.com\/discussion\/106601\/please-can-someone-help-with-this-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106601\/please-can-someone-help-with-this-formula","format":"Rich","lastPost":{"discussionID":106601,"commentID":381177,"name":"Re: Please can someone help with this formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381177#Comment_381177","dateInserted":"2023-06-19T15:54:15+00:00","insertUserID":144360,"insertUser":{"userID":144360,"name":"Hollie Green","url":"https:\/\/community.smartsheet.com\/profile\/Hollie%20Green","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T22:11:33+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/MRW4VGYRA7HG\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-19T17:03:50+00:00","dateAnswered":"2023-06-19T15:54:15+00:00","acceptedAnswers":[{"commentID":381177,"body":"
It needs to be a countifs instead of countif<\/p>
=COUNTIFS([column4]2:[column4]5,\"Qualification\",[column5]2:[column5]5,\"Q4-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":[]}">
             

               

                
热门文章

               

               
    
                
  • 组——一个组中有多少用户?
    帮助文件显示，您可以批量上传1000封邮件到一个群组。这是组中的最大用户数吗?我找不到说明一个组中可以有多少用户的文档。蒂雅
    • 
                
  • 有几个条件的公式
    嗨，我上周在做一个公式，但我仍然在努力解决这个问题的第二个标准。它的设置方式，根据输入的日期更新字段。它的工作原理如下:=IFERROR(IF([Client review Required]@row = "Yes"， IF([实际提交日期]@row = "" "Pending"， (IF([实际…]
    • 
                
  • 请问有人能帮我弄一下这个公式吗
    我试图计算有多少“资格”阶段有一个给定的财政期间，例如第四季度-2023年，我知道我错过了一些东西，但计数的每一个变化，如果我尝试过的公式似乎不起作用，这将是一些非常简单的东西，我试图使复杂，但任何帮助将是……
    •