Creating a Dashboard using Formulas
Hello,
I'm creating a dashboard and I am trying to figure out how to add two different sections (a CAR and Task). I am looking how to add how many CAR's and how many Task were issued for each month. I do have a formula page that states how many for each but I'm not sure how to state per month to be included. Please advise! Thanks in advance!
Best Answer
-
=SUM(Select the cells you want to sum)
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
Answers
-
You would need to create a formula on that page that counts for the items per month, or if you have it to where a SUM function could SUM the counts to make up the month, do that. I would need to see a screenshot of your sheet to be able to say which one I would do, maybe even your formula too.
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
-
I also wanted to add, on my formula page, I have how many CAR's and Task per month (not separate, a total of) How would I add those together? Thanks!
-
=SUM(Select the cells you want to sum)
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.1K Get Help
- 448 Global Discussions
- 154 Industry Talk
- 503 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 80 Community Job Board
- 512 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives