Tracking a sum from separate column of specific values
Hello,
First, I want to thank all of you for your help on this community. I'm learning a lot and this place has helped me out immensely. I've looked around and have found some similar questions, but I can't seem to get this to work, so I want to turn it over to y'all. So let me start with a snapshot of my sheet.
What I would like to do is have an Occurrence Sum that is associated with each Communicator that is automatically updated. Our attendance occurrences have different point values associated with, as you can see with Tardy vs. Leave early, so I imagine I would need to reference the Point value column. Yellow has 2 occurrences that should total 1.4. I would like to have an updating column that would always display the sum total of the their occurrences in relation to the communicator.
My bonus question is if there could be a way to filter it so that it would only display that last 365 days, since occurrences fall off after a year passes by. I'm not sure this is possible, but I thought I would shoot my shot and see if any of you knew how to do this.
Thank you!
Best Answer
-
Give this a try...
=SUMIFS([Occurrence Point Value]:[Occurrence Point Value], [Communicator Name]:[Communicator Name], @cell = [Communicator Name]@row, [Occurrence Date]:[Occurrence Date], @cell >= TODAY(-365))
Answers
-
Give this a try...
=SUMIFS([Occurrence Point Value]:[Occurrence Point Value], [Communicator Name]:[Communicator Name], @cell = [Communicator Name]@row, [Occurrence Date]:[Occurrence Date], @cell >= TODAY(-365))
-
Paul, this worked really well. Thank you!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!