Help Create Metric
![ESN](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
Hi, Can someone help me create a formula on my metric sheet. I have two columns i want to include from my sheet one Titled "Project Status" which has drop downs for Where the project is at eg Budget, Won, Lost, the other column is Titled "Total" which has the price of project. What im trying to do is create a formula on the metric sheet to use on my dashboard to show a chart where i can get the totals for each Budget, Won, Lost ect. Can't seem to figure it out.
Answers
-
Hi there,
To show totals for each project status on your dashboard:
- Create a Summary Table: List each status (e.g., Budget, Won, Lost) in one column.
- Use SUMIF Formula: In the next column, use =SUMIF([Project Status Column], "Status", [Total Column]) for each status.
- Chart on Dashboard: Use these totals to create a chart on your dashboard.
Example:
- For "Budget": =SUMIF(Sheet1!A:A, "Budget", Sheet1!B:B)
- For "Won": =SUMIF(Sheet1!A:A, "Won", Sheet1!B:B)
- For "Lost": =SUMIF(Sheet1!A:A, "Lost", Sheet1!B:B)
Hope this helps!
Best,
RHJ
-
Place a Project Status on your metric sheet. Underneath, on rows, put Budget, Won, Lost like below.
In Total rows, use formula. In this formula the Project
=CountIF({Your Reference Sheet Project Status}, $Label13)
-
Thank you this worked
=SUMIF(Sheet1!A:A, "Budget", Sheet1!B:B)
what if i wanted to combine two titles Budget and Tender
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives