报告上的多个下拉菜单

fionam_c · 04/27/22

你好,

我想做一份报告，从多个下拉列表中显示内容;在这种情况下，是25美分。这些项目可以运行多个季度，我希望它们在每个季度都显示出来。我已经创建了分组与四分之一，但它不会显示数据时，在多个下拉，只有当它是一个单一的选择一个。有人能帮帮忙吗?

夏天 · 04/27/22

嗨@fionam_c

一种解决方法可能是创建一个助手列，从阶段下拉列表中提取值。然后在报表上使用该helper列，而不是下拉列。

例如:=phase drop down

在创建要在报表上使用的助手列时，我发现这些技巧很有帮助

将列命名为与其提取数据的列相同的列，但添加。最后。
锁定并隐藏主工作表上的列，这样用户就不会意外地更改或引用它
添加列描述来说明列的功能

fionam_c · 04/28/22

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

One work around may be to create a helper column that pulls the value from the phase drop down. Then use that helper column on the report instead of the drop down column. <\/p>

Example: =phase drop down<\/p>

Tips I find helpful when creating a helper column to be used on reports<\/p>

Name the column the same as the column it's pulling data from but add a . at the end. <\/li>

Lock and hide the column on the main sheet so users don't accidently change it or reference it<\/li>

Add a column description to state the function of the column <\/li><\/ul>","bodyRaw":"[{\"insert\":\"Hi \"},{\"insert\":{\"mention\":{\"name\":\"fionam_c\",\"userID\":146004}}},{\"insert\":\" \\nOne work around may be to create a helper column that pulls the value from the phase drop down. Then use that helper column on the report instead of the drop down column. \\nExample: =phase drop down\\nTips I find helpful when creating a helper column to be used on reports\\nName the column the same as the column it's pulling data from but add a . at the end. \"},{\"attributes\":{\"list\":{\"depth\":0,\"type\":\"bullet\"}},\"insert\":\"\\n\"},{\"insert\":\"Lock and hide the column on the main sheet so users don't accidently change it or reference it\"},{\"attributes\":{\"list\":{\"depth\":0,\"type\":\"bullet\"}},\"insert\":\"\\n\"},{\"insert\":\"Add a column description to state the function of the column \"},{\"attributes\":{\"list\":{\"depth\":0,\"type\":\"bullet\"}},\"insert\":\"\\n\"}]","format":"rich","dateInserted":"2022-04-27T14:45:29+00:00","insertUser":{"userID":143022,"name":"Summer","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Summer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-05-05T15:18:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/327560#Comment_327560","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/327560#Comment_327560

嗨@Summer，

我需要能够拉多个值通过在同一行，因此多选下拉。

报告上的多个下拉菜单

答案

帮助文章参考资料欧宝体育app官方888

类别