为仪表板图表添加数据行需要重新格式化吗?

Rainyvanc
Rainyvanc
编辑12/09/19 内容基本知识

我创建了一个表格来存放我的数据,并创建了一堆与之相关的图表。例如,每行表示当周的数据。

但是……当我为新的一周添加新的数据行时,我发现我必须重新建立图表的数据字段,当我这样做时,我失去了图表的所有格式,必须再次重置所有图表。这不是长期可控的。例如,我有折线图,每个图表中只使用特定的数据列,垂直轴调整数据范围,图例位置等,一旦我指定了新的数据范围,我就失去了一切。

如果可以设置它,这样数据范围就会自动扩展,而不必进入并重置它,并且如果重置数据范围,那么格式化的所有内容都不会丢失。

谢谢!

评论

  • J.克雷格·威廉姆斯
    J.克雷格·威廉姆斯 ✭✭✭✭✭✭

    我同意。请写一个增强请求。

    https://app.smartsheet.com/b/form/739aa75f30ca43a8a22eb53e4da7d409

    我尝试构建使用滚动日历的系统。我刚刚完成了一个有5个季度日历的系统——当前季度、下一个季度和上一个季度。

    在可预见的将来,不需要对输入数据的(几个)表提供的仪表板或报告进行更改。

    我也尽量避免使用当前时间段名称的表格,例如TASKS 2018。

    相反,我使用了TASKS或TASKS CURRENT YEAR。

    在时间周期结束时,表通过给定它们的时间周期名称进行归档,并且各种对象可能需要更新以显示历史记录,但我也尝试在设计中避免这种情况。

    即便如此,至少当前的生产可以在交叉期间继续进行,而不会产生不ob欧宝娱乐app手机下载必要的压力。

    克雷格

OMG, I didn't click on the widget box, now I see the edit option. Thanks so much, this is going to be a game changer for me!<\/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":106511,"type":"question","name":"Smartsheet Form & File Attachment","excerpt":"Hello, is it possible to have the file uploaded on a smartsheet form to be attached to the email notification?","categoryID":321,"dateInserted":"2023-06-15T17:47:43+00:00","dateUpdated":null,"dateLastComment":"2023-06-19T18:45:05+00:00","insertUserID":162431,"insertUser":{"userID":162431,"name":"Syd","title":"Analytics Manager","url":"https:\/\/community.smartsheet.com\/profile\/Syd","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!CRvWwjtq8Dw!neNVX5cBEbo!R6y12vmDgYo","dateLastActive":"2023-06-19T18:44:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":138637,"lastUser":{"userID":138637,"name":"StevenBlackburnMBA","title":"Director, Informatics Innovation","url":"https:\/\/community.smartsheet.com\/profile\/StevenBlackburnMBA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/30MFCHQD4VJ8\/nA6GUCC5S5SQG.jpg","dateLastActive":"2023-06-19T21:30:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":69,"score":null,"hot":3374056368,"url":"https:\/\/community.smartsheet.com\/discussion\/106511\/smartsheet-form-file-attachment","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106511\/smartsheet-form-file-attachment","format":"Rich","lastPost":{"discussionID":106511,"commentID":381199,"name":"Re: Smartsheet Form & File Attachment","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381199#Comment_381199","dateInserted":"2023-06-19T18:45:05+00:00","insertUserID":138637,"insertUser":{"userID":138637,"name":"StevenBlackburnMBA","title":"Director, Informatics Innovation","url":"https:\/\/community.smartsheet.com\/profile\/StevenBlackburnMBA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/30MFCHQD4VJ8\/nA6GUCC5S5SQG.jpg","dateLastActive":"2023-06-19T21:30:05+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-19T18:44:06+00:00","dateAnswered":"2023-06-15T18:43:26+00:00","acceptedAnswers":[{"commentID":380872,"body":"

@Syd<\/a> - okay, I attached a word doc to this comment that explains it step by step. Basically, I have my Google Chrome browser laid out to ask me anytime I download a file, where I want the file saved. Some automatically default it to a certain folder, and sometimes it just is defaulted automatically to a downloads folder... I'd check that as well, or even check the downloads folder to verify. Sometimes, it may download and send it to a folder that you may not know its sending to.<\/p>


<\/p>

Let me know if this helps at all!<\/p>


<\/p>

\n \n Attachments in Smartsheet 6.15.23.docx\n <\/a>\n<\/div>\n


<\/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":106565,"type":"question","name":"Index Collect Error","excerpt":"Hello! I am trying to use an INDEX COLLECT function to get a number value. It uses the following: Total number Filter of the Month Matches names between two sheets This is the formula I am using and it is returning an Incorrect Argument Set error. =INDEX(COLLECT({OPK Monthly Report 22-23 Unfilled 0-3}, {OPK Monthly Report…","categoryID":321,"dateInserted":"2023-06-16T18:59:59+00:00","dateUpdated":null,"dateLastComment":"2023-06-16T20:03:20+00:00","insertUserID":136885,"insertUser":{"userID":136885,"name":"Fiona Murray","url":"https:\/\/community.smartsheet.com\/profile\/Fiona%20Murray","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!mvkr3-YRWLs!DWcoQ8Zayjs!t-XvuMBQJJa","dateLastActive":"2023-06-16T20:03:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":136885,"lastUser":{"userID":136885,"name":"Fiona Murray","url":"https:\/\/community.smartsheet.com\/profile\/Fiona%20Murray","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!mvkr3-YRWLs!DWcoQ8Zayjs!t-XvuMBQJJa","dateLastActive":"2023-06-16T20:03:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":39,"score":null,"hot":3373888999,"url":"https:\/\/community.smartsheet.com\/discussion\/106565\/index-collect-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106565\/index-collect-error","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106565,"commentID":381077,"name":"Re: Index Collect Error","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381077#Comment_381077","dateInserted":"2023-06-16T20:03:20+00:00","insertUserID":136885,"insertUser":{"userID":136885,"name":"Fiona Murray","url":"https:\/\/community.smartsheet.com\/profile\/Fiona%20Murray","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!mvkr3-YRWLs!DWcoQ8Zayjs!t-XvuMBQJJa","dateLastActive":"2023-06-16T20:03:10+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-19T08:10:23+00:00","dateAnswered":"2023-06-16T19:39:25+00:00","acceptedAnswers":[{"commentID":381073,"body":"

Might be you need to move the first )<\/p>

try this<\/p>

=INDEX(COLLECT({OPK Monthly Report 22-23 Unfilled 0-3}, {OPK Monthly Report 22-23 Month}, \"April\", {OPK Monthly Report 22-23 Grantee Name}, Grantee@row), 1)<\/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":254,"urlcode":"Formulas","name":"Formulas"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=341&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&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":5386,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

使用Smartsheet的趋势