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))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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! 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 301 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!