使用Smartsheet

Find answers to your core Smartsheet application, add ons and integration questions, here.

I hope you're well and safe!<\/p>

You could maybe create a so-called Metrics Sheet where you collect data from multiple sheets and then add them together.<\/p>

Make sense?<\/p>

Would that work\/help? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic weekend!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

受欢迎的标签

 Formulas8,903

Project Management4,095

Sheets3,334

Reports2296年

形式2,035

functionality1,931

IT & Operations1,688

Support1,415

Cell linking1,374

Enhancement Request1,359

Email Notifications1,348

Account and User Management1,345

Automations1,291

Integrations1,152

Construction1,062

Technology1,041

Conditional Formatting1,030

Dashboards887

Manufacturing851

Sharing and Collaboration793

API and Developers744

Calendar View708

Product Development707

Gantt View705

Update Requests690

Hi @John Stanik<\/a> <\/p>
I hope you're well and safe!<\/p>
You could maybe create a so-called Metrics Sheet where you collect data from multiple sheets and then add them together.<\/p>
Make sense?<\/p>
Would that work\/help? <\/p>
I hope that helps!<\/p>
Be safe, and have a fantastic weekend!<\/p>
Best,<\/p>
Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-04 19:02:23","updateUser":{"userID":141918,"name":"John Stanik","url":"https:\/\/community.smartsheet.com\/profile\/John%20Stanik","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-05T15:55:21+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":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"}]},{"discussionID":97398,"type":"question","name":"Why does my dashboard pie chart not show the same information as the data it is charting?","excerpt":"The data below is what I am trying to chart as a pie chart. The pie chart is only showing 708.14 and 1992.83 but if I make the same chart a bar graph it shows the data correctly. Why is this?","categoryID":321,"dateInserted":"2022-11-04T19:08:41+00:00","dateUpdated":null,"dateLastComment":"2022-11-04T19:18:42+00:00","insertUserID":154589,"insertUser":{"userID":154589,"name":"Claire D","url":"https:\/\/community.smartsheet.com\/profile\/Claire%20D","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-04T19:14:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":154589,"lastUser":{"userID":154589,"name":"Claire D","url":"https:\/\/community.smartsheet.com\/profile\/Claire%20D","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-04T19:14:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":11,"score":null,"hot":3335179043,"url":"https:\/\/community.smartsheet.com\/discussion\/97398\/why-does-my-dashboard-pie-chart-not-show-the-same-information-as-the-data-it-is-charting","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97398\/why-does-my-dashboard-pie-chart-not-show-the-same-information-as-the-data-it-is-charting","format":"Rich","tagIDs":[292],"lastPost":{"discussionID":97398,"commentID":350057,"name":"Re: Why does my dashboard pie chart not show the same information as the data it is charting?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/350057#Comment_350057","dateInserted":"2022-11-04T19:18:42+00:00","insertUserID":154589,"insertUser":{"userID":154589,"name":"Claire D","url":"https:\/\/community.smartsheet.com\/profile\/Claire%20D","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-04T19:14:23+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\/547SF11O6IM4\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-04T19:18:48+00:00","dateAnswered":"2022-11-04T19:18:42+00:00","acceptedAnswers":[{"commentID":350057,"body":"
I just realized why! It is because the values are negative which pie charts are unable to handle.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-04 19:18:48","updateUser":{"userID":154589,"name":"Claire D","url":"https:\/\/community.smartsheet.com\/profile\/Claire%20D","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-04T19:14:23+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":[{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"}]},{"discussionID":97369,"type":"question","name":"Approval Workflow: Triggered even though condition is NOT met","excerpt":"Workflows: Two different approval workflows currently, see below. Event: When a project is moving from Discovery into Evaluation, an approval is sent requested. If it is Declined, BOTH of the declined branch notifications (the \"request for update\" in each screen shot below) are triggering, resulting in the PM receiving two…","categoryID":321,"dateInserted":"2022-11-04T13:14:39+00:00","dateUpdated":null,"dateLastComment":"2022-11-04T15:09:41+00:00","insertUserID":154557,"insertUser":{"userID":154557,"name":"crittcg","url":"https:\/\/community.smartsheet.com\/profile\/crittcg","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-04T15:28:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":154557,"lastUser":{"userID":154557,"name":"crittcg","url":"https:\/\/community.smartsheet.com\/profile\/crittcg","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-04T15:28:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":53,"score":null,"hot":3335144660,"url":"https:\/\/community.smartsheet.com\/discussion\/97369\/approval-workflow-triggered-even-though-condition-is-not-met","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97369\/approval-workflow-triggered-even-though-condition-is-not-met","format":"Rich","lastPost":{"discussionID":97369,"commentID":349992,"name":"Re: Approval Workflow: Triggered even though condition is NOT met","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/349992#Comment_349992","dateInserted":"2022-11-04T15:09:41+00:00","insertUserID":154557,"insertUser":{"userID":154557,"name":"crittcg","url":"https:\/\/community.smartsheet.com\/profile\/crittcg","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-04T15:28:09+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\/EMGQQH8VHAHX\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-04T15:10:32+00:00","dateAnswered":"2022-11-04T14:55:21+00:00","acceptedAnswers":[{"commentID":349982,"body":"
The way you can read branches of an automation like this is as if they are their own separate automations.<\/p>

<\/p>
So that second portion reads as \"When [Most Recent Approval] changes to \"Approved\"//www.santa-greenland.com/community/categories/using-smartsheet/\". It reads the same way in both automations. Even though they are branched out from the same automation workflow, they have their own separate triggers. The branching just helps with organization of your workflows.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-04 15:10:32","updateUser":{"userID":154557,"name":"crittcg","url":"https:\/\/community.smartsheet.com\/profile\/crittcg","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-04T15:28:09+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":[]}">

使用Smartsheet

Category List

受欢迎的标签