用作自动化触发器的下拉选项


你好。当我设置一个更新请求或通知自动化时,当我选择一个字段,“更改到”时,所有的下拉选项都不在那里。

在某些领域,即使我在表格上有选项,也没有选项。在少数情况下,3个选项中只有1个

一个例子,它们在那里,加上一个额外的。然后是下拉值的截图

image.png
image.png


什么都没有的例子:

image.png


image.png
image.png


我用同样的方式设置了所有的列。(单个选择,限制到下拉框选中)。


有什么建议吗?

答案

  • 在自动化中,在“触发”下拉菜单下,它显示了名为“药物”的列中的现有值。

    我知道这听起来很明显,但这意味着在“药物”列中,您的值不是来自列属性中的下拉值。

    可能发生的情况是,您在列属性下拉列表中初始值不同,并在某个时刻更改了它们。Smartsheet会提醒你列不符合现有的下拉值,但它不会改变它们或突出显示它们

    (例如,您现在在列中有不同的值,它们不是来自您的下拉菜单)。

    例如,在触发下拉菜单中,你有这两个值,不同的是一个在末尾有句号,另一个没有:

    image.png


    对于第二个问题,您的列中有下拉值,但没有显示在触发器中,我被难住了。试着在列属性的两个值之间放一行空格,我想知道smartsheet是否“看到”两个不同的值。

  • 保罗新来的
    保罗新来的 ✭✭✭✭✭✭

    @Andrew1983当触发器有其他选项时,第一点是正确的。


    这也是为什么有时触发器没有选项的原因。


    这就像建立一个报告。您只能根据工作表中已经存在的数据(不是列属性,而是实际的行本身)进行筛选。


    因此,如果列属性中有选项A - G,但行数据中只选择了选项A - C,那么触发器(和报表生成器)将只显示A - C的选项。


    要解决这个问题,你有两个选择……

    1. 使用“虚拟数据”填充每一行下的选项,设置一切,然后删除“虚拟行”。
    2. 使用它等于的条件选项,你可以输入任何你想要的,然后输入从触发器/报告/表格中缺少的选项。

    thinkspi.com

  • 谢谢你的帮助。

    我从我的工作表中删除了不匹配的数据,从而删除了重复的条目。


    我确实缩短了下拉列表中选项的措辞。缩短的选项出现了。

    是否存在下拉选项的潜在字符长度?我知道我的时间很长。

  • 保罗新来的
    保罗新来的 ✭✭✭✭✭✭

    除了每个单元格不超过4000个字符(包括空格)的标准外,我还没有看到下拉菜单中对字符长度的任何限制,但如果超过了这个标准,就无法在不收到错误消息的情况下保存工作表。

    我知道输入不同选项的数量是有限制的,但它是数千个(甚至可能是数万个,但我已经有一段时间没有进行测试了)。


    @Andree Stara@Genevieve P@Mike Wilday您是否知道下拉列表中的单个字符串是否有字符限制,或者对于可以用作自动化触发器的内容是否有字符限制?

    thinkspi.com

  • 迈克Wilday
    迈克Wilday ✭✭✭✭✭✭

    我没有遇到任何挑战,但我们的下拉选项通常非常短。

  • 吉纳维芙P。
    吉纳维芙P。 员工管理

    @Brandee Pak@Paul新来的

    我为耽搁道歉!

    我做了一些测试,我可以确认当一个下拉值超过100个字符它不会作为一个选项出现在工作流中。我检查了我们的支持团队,这是注意到的预期行为-触发值将需要低于100个字符。

    听起来你可以缩短你的值,这太棒了!作为一种替代方案,您可以让一个列带有一个简短的下拉值(例如“YES”和“NO”),然后用一个辅助列描述YES或NO表示什么。

    欢呼,

    吉纳维芙

  • 保罗新来的
    保罗新来的 ✭✭✭✭✭✭

    @Genevieve P谢谢你提供的信息!我也喜欢使用更短的选项和“描述”列的解决方法。

    thinkspi.com

Thank you for the quick reply kirstie858<\/strong><\/a>!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-06 04:04:01","updateUser":{"userID":155650,"name":"vponis","url":"https:\/\/community.smartsheet.com\/profile\/vponis","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu123eObw5fLQtcthrpqsoWY319L3hmQyAsPTpm6=s96-c","dateLastActive":"2022-12-06T04:02:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":98392,"type":"question","name":"Summary Formula Result in new Formula","excerpt":"I am generating multiple results in a Summary Sheet. I would like to use these results in a new formula within the same Summary, is this possible? SS_Result1 SS_Result2 new formula =sum([SS-Result1]-[SS-Result2]) otherwise I have to combine the formulas within each against themselves, kinda tedious","categoryID":321,"dateInserted":"2022-12-04T20:14:28+00:00","dateUpdated":null,"dateLastComment":"2022-12-05T14:48:26+00:00","insertUserID":154303,"insertUser":{"userID":154303,"name":"SkiPatrolScott","url":"https:\/\/community.smartsheet.com\/profile\/SkiPatrolScott","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-05T17:39:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":154303,"lastUser":{"userID":154303,"name":"SkiPatrolScott","url":"https:\/\/community.smartsheet.com\/profile\/SkiPatrolScott","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-05T17:39:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":20,"score":null,"hot":3340437774,"url":"https:\/\/community.smartsheet.com\/discussion\/98392\/summary-formula-result-in-new-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98392\/summary-formula-result-in-new-formula","format":"Rich","lastPost":{"discussionID":98392,"commentID":353136,"name":"Re: Summary Formula Result in new Formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/353136#Comment_353136","dateInserted":"2022-12-05T14:48:26+00:00","insertUserID":154303,"insertUser":{"userID":154303,"name":"SkiPatrolScott","url":"https:\/\/community.smartsheet.com\/profile\/SkiPatrolScott","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-05T17:39:25+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":"2022-12-05T14:48:17+00:00","dateAnswered":"2022-12-04T23:22:27+00:00","acceptedAnswers":[{"commentID":353095,"body":"

Hey @SkiPatrolScott<\/a> <\/p>

Yes, you can use an existing summary field in another summary field within the same sheet. You can either click into the formula field of the existing formula to add to new formula, or type out the field name. Summary fields use a # in place of a row indicator. Using your example from above:<\/p>

=new formula =[SS-Result1]#<\/strong>-[SS-Result2]#<\/strong><\/p>

If this doesn't make sense, help me understand where I lost you and I will try to explain it better.<\/p>

Kelly<\/p>"},{"commentID":353136,"body":"

Thanks @Kelly Moore<\/a> , I did have to add a ( around the equation ) but it did work.<\/p>

=sum([summary field1]#-[summary field2]) the correct answer was produced.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-05 14:48:17","updateUser":{"userID":154303,"name":"SkiPatrolScott","url":"https:\/\/community.smartsheet.com\/profile\/SkiPatrolScott","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-05T17:39:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":98381,"type":"question","name":"Smartsheet Form Logo Question","excerpt":"Hello Smartsheet Community, I have a question that is probably obvious that I am overlooking it. I am creating and I am incorporating a logo into the form. I am able to incorporate the logo, but it's small when you open the form. Is there a way to make the logo bigger? Or, elongate the image so it goes across the top of…","categoryID":321,"dateInserted":"2022-12-02T20:32:19+00:00","dateUpdated":null,"dateLastComment":"2022-12-03T18:37:12+00:00","insertUserID":147643,"insertUser":{"userID":147643,"name":"Anthony DAmbrosio","url":"https:\/\/community.smartsheet.com\/profile\/Anthony%20DAmbrosio","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-05T17:14:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":112221,"lastUser":{"userID":112221,"name":"Kelly Moore","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Moore","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jnPa4zng1Pw!n1lbH6Wxgbo!UbxYNkVsKJw","dateLastActive":"2022-12-06T02:41:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":23,"score":null,"hot":3340106371,"url":"https:\/\/community.smartsheet.com\/discussion\/98381\/smartsheet-form-logo-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98381\/smartsheet-form-logo-question","format":"Rich","lastPost":{"discussionID":98381,"commentID":353078,"name":"Re: Smartsheet Form Logo Question","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/353078#Comment_353078","dateInserted":"2022-12-03T18:37:12+00:00","insertUserID":112221,"insertUser":{"userID":112221,"name":"Kelly Moore","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Moore","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jnPa4zng1Pw!n1lbH6Wxgbo!UbxYNkVsKJw","dateLastActive":"2022-12-06T02:41:20+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/868U3BF057NI\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-12-05T17:14:43+00:00","dateAnswered":"2022-12-03T18:37:12+00:00","acceptedAnswers":[{"commentID":353078,"body":"

Hello @Anthony DAmbrosio<\/a> <\/p>

The following reference states the dimensions for a form logo is 300pix wide x 52pix tall. <\/p>

\n \n https:\/\/help.smartsheet.com\/articles\/2478921-create-a-quality-logo-to-brand-your-smartsheet-items#toc-where-your-logo-appears-and-how-smartsheet-resizes-it\n <\/a>\n<\/div>

You may need to play with your layout, as suggested in the article, to maximize the size of the text.<\/p>

Kelly<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-05 17:14:43","updateUser":{"userID":147643,"name":"Anthony DAmbrosio","url":"https:\/\/community.smartsheet.com\/profile\/Anthony%20DAmbrosio","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-05T17:14:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">