How to create a weekly/monthly report
Answers
-
Apologies! Been away, one of my daughters graded up in Taekwondo today.
I see that Paul is helping you. Did you get it working?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå No worries, I figured that you were busy. I tried Paul's suggestion but I am still receiving an error message. Could you please take a look at the sheet and let me know what I am doing wrong?
-
What steps did you take to create the cross sheet reference? Is the formula showing in your screenshot fully? For some reason I am unable to open it.
I notice that the opening parenthesis after COUNTIFS is not color coded to match anything else and the opening parenthesis before the first IFERROR is matched up with the final closing parenthesis. It looks like you are using an AND function but don't actually have the AND in there...
=COUNTIFS({Range 1}, {Range 2}, AND(IFERROR(MONTH(@cell), 0) = 4, IFERROR(YEAR(@cell), 0) = 2020))
-
I took another look through the thread. It looks like there were a few things that got dropped off as the formulas got tweaked. Here are two formulas for you. One to sum a range and another to count the dates.
=SUMIFS({Range 1}, {Range 2}, AND(IFERROR(MONTH(@cell), 0) = 4, IFERROR(YEAR(@cell), 0) = 2020))
=COUNTIFS({Range 2}, AND(IFERROR(MONTH(@cell), 0) = 4, IFERROR(YEAR(@cell), 0) = 2020))
Sorry for getting it mixed up...
EDIT: I am going to recommend the COUNTIFS. Based on one of your previous screenshots using the SUMIFS, you are referencing the timestamp column as the range to SUM. I assume you are wanting to count instances and not necessarily add up a bunch of other numbers based off of the date.
If in fact you ARE adding up other numbers based on the dates, then you will want to use the SUMIFS instead.
-
YAY!!! I think that I have what I needed.
Thanks @Paul Newcome and @Andrée Starå!!! You guys are the BEST!!!
-
Excellent!
Thanks!
Gad that you got it working!
Happy to help!
Have a fantastic weekend!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Happy to help! 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!