Help Create Metric
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
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives