将小部件克隆到另一个视图?

乔什·加西亚 ✭

07/12/17 编辑12/09/19 在2017年发布的文章

我和我的团队一起审查了一个“演示”视图，我已经得到了一套很好的KPI。现在我们对外观和感觉很满意，我想把它们发布到一个不同的地方，面向更广泛的受众。

我知道有一个“克隆”按钮。我没有看到“克隆”一个小部件到另一个视图的选项。

手动重新创建小部件是唯一的选择吗?

提前感谢任何反馈!

标签:

0 ·

L_123 ✭✭✭✭✭✭

07/12/17

我不知道您是否已经开始制作新的瞄准具，但是您可以将瞄准具保存为新瞄准具(复制整个瞄准具)并保留所有小部件，然后从那里编辑它。

0 · 在Facebook上分享在Twitter上分享
乔什·加西亚 ✭

07/12/17

说得好，谢谢。这种想法可能会奏效一次，尽管“公开”的观点正变得越来越复杂。在某种程度上，将“已发布”的内容添加到我的新视图中需要更多的工作。

0 · 在Facebook上分享在Twitter上分享
J.克雷格·威廉姆斯 ✭✭✭✭✭✭

07/24/17

Josh和任何可以从中受益的人，请在这里提交产品请求ob欧宝娱乐app手机下载

https://app.smartsheet.com/b/form?EQBCT=739aa75f30ca43a8a22eb53e4da7d409

或者使用线程右侧的链接。

克雷格

0 · 在Facebook上分享在Twitter上分享

这次讨论已经结束了。

类别

[End Date]@row, Status@row = \"Not Started\"), AND(TODAY()>[End Date]@row, Status@row = \"In Progress\")), \"Red\", IF(OR(AND(TODAY(-5)>[End Date]@row, Status@row = \"Not Started\"), AND(TODAY(-5)>[End Date]@row, Status@row = \"In Progress\")), \"Yellow\", IF(Status@row =…","categoryID":321,"dateInserted":"2023-06-05T15:02:28+00:00","dateUpdated":null,"dateLastComment":"2023-06-05T15:26:32+00:00","insertUserID":159166,"insertUser":{"userID":159166,"name":"Carole M.","url":"https:\/\/community.smartsheet.com\/profile\/Carole%20M.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-05T15:29:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-05T15:31:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":15,"score":null,"hot":3371957940,"url":"https:\/\/community.smartsheet.com\/discussion\/106011\/why-do-i-get-a-incorrect-argument-set-error-with-the-formula-below","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106011\/why-do-i-get-a-incorrect-argument-set-error-with-the-formula-below","format":"Rich","lastPost":{"discussionID":106011,"commentID":378815,"name":"Re: Why do I get a #Incorrect argument set error with the formula below\/","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/378815#Comment_378815","dateInserted":"2023-06-05T15:26:32+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-05T15:31:40+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-05T15:22:11+00:00","dateAnswered":"2023-06-05T15:14:09+00:00","acceptedAnswers":[{"commentID":378809,"body":"

14 opening parentheses, 15 closing parentheses.<\/p>"},{"commentID":378815,"body":"

It's an easy mistake to make. Glad I could help.<\/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":105993,"type":"question","name":"Formula Help","excerpt":"Hello, Last formula I need to figure out to finish this template. @Kelly Moore You have been so incredibly helpful, if you are able to help me on this last one I owe you one! I know I have an error in the formula or maybe using the wrong one. I am trying to pull the Start Date and End Date on the current sheet, taking into…","categoryID":322,"dateInserted":"2023-06-04T10:18:38+00:00","dateUpdated":null,"dateLastComment":"2023-06-04T13:26:50+00:00","insertUserID":162046,"insertUser":{"userID":162046,"name":"NuGenAdmin","title":"Director of Operations","url":"https:\/\/community.smartsheet.com\/profile\/NuGenAdmin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-04T13:13:34+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":"2023-06-05T13:07:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":37,"score":null,"hot":3371760928,"url":"https:\/\/community.smartsheet.com\/discussion\/105993\/formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105993\/formula-help","format":"Rich","lastPost":{"discussionID":105993,"commentID":378730,"name":"Re: Formula Help","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/378730#Comment_378730","dateInserted":"2023-06-04T13:26:50+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":"2023-06-05T13:07:21+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\/ETI4CR3HK742\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-05T07:00:39+00:00","dateAnswered":"2023-06-04T13:13:12+00:00","acceptedAnswers":[{"commentID":378728,"body":"

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

Happy to help. Some syntax errors to watch out for in the future - I believe in your formulas you are trying to use the ampersand as a join. It's not needed and<\/em> smartsheet doesn't use the ampersand for join. When needing to concatenate, you use a plus sign. But you don't need to join an equal sign to the other part of any expression. Also, enclosing numbers or arithmetic signs in quotes converts them to a textstring where they will be behave as if you placed any other letter of the alphabet in a sentence.<\/p>

Thanks for the screenshots AND the typed formula. Both are super helpful.<\/p>

=SUMIFS({Total Production Per Day}, {Generation Tracker Range 1},[Project Name]@row, {Generation Tracker Range 2}, >=[Start Date]@row, {Generation Tracker Range 2}, <=[End Date]@row)<\/p>

Will this work for you<\/p>

Yes. I have had to use this when clients wanted to include help text on the top row of the sheet but needed column formulas elsewhere.<\/p>

<\/p>

I use an auto-number column (called \"Auto\" in this example) and a text\/number column (called \"Row\" in this example) to get the row numbers as usable values on the sheet. The column formula in the \"Row\" column is:<\/p>

=MATCH(Auto@row, Auto:Auto, 0)<\/p>

<\/p>

Then in any column where I needed a column formula, I would use what @Carson Penticuff<\/a> suggested.<\/p>

=IF(Row@row = 1, \"helper text, column name, or whatever you want in the top row\", desired_column_formula)<\/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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":527,"urlcode":"column-where-used","name":"column where used"}]}],"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">