How to Sum values from one sheet (by month) into another sheet
Hi
I have an online form that collects referrals completed by our clinical allied health team weekly. I am trying to pull data (specifically number of falls) from this sheet into another sheet that will collate this data per month to add to a dashboard (to be then compared over a quarterly period). I have a date column also on the source sheet and a column next to this that uses the MONTH function.
The Formula I'm using seems to run but returns the wrong value.
=SUMIF({Clinician Service Report V 1.0 Range 1}, MONTH({Clinician Service Report V 1.0 Range 2}) = 1)
Bit of a Smartsheet amateur, I may be totally on the wrong track. What is the best way to collect and add number of falls per month from an online form that's collected weekly? I've tried other methods such as linking cells/columns but have run into the issue of a new row being added every time the form is completed and the link or formula I'm using not applying.
Best Answer
-
Figured it out!
My Formula was backwards! Range 2 needed to be entered before range 1 and Month function wasn't required in formula
Answers
-
Figured it out!
My Formula was backwards! Range 2 needed to be entered before range 1 and Month function wasn't required in formula
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!