Metrics in capturing SUM per Monthly
Hi Everyone,
We are aiming to create a new metric and visualization that will allow us to automatically calculate the total numbers of FTE per month. Based on the sample data set below, the calculation will go like this:
February 2021 -> 110 + 200 + 200 = 510
March 2021 -> 20 = 20
April 2021 -> 120 + 4 + 4 = 128
May 2021 -> 50 = 50
Given this, I'm hanging on the part on how to capture the totals entered in each row.
Hope someone from the community can help me with how to proceed to capture this metric data.
(IFERROR(MONTH(@cell), 0) = 2, IFERROR(YEAR(@cell), 0) = 2021)
(IFERROR(MONTH(@cell), 0) = 3, IFERROR(YEAR(@cell), 0) = 2021))
(IFERROR(MONTH(@cell), 0) = 4, IFERROR(YEAR(@cell), 0) = 2021))
(IFERROR(MONTH(@cell), 0) = 5, IFERROR(YEAR(@cell), 0) = 2021))
Answers
-
Hi,
This should work for each month =SUMIFS([FTE Count]:[FTE Count],[date received]:[date received], AND((IFERROR(MONTH(@cell), 0) = 2, IFERROR(YEAR(@cell), 0) = 2021))
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!