Formula for projects completed by month
Im looking for a total # of projects that are completed by Month and year
Best Answer
-
Hey @TPALJA
What about creating a Report? Then you can Filter by if the Projects say "Complete", then Group by the Year column, add a second-level Grouping for the Month column, and use Summarize to COUNT how many rows are in each Group.
Here's a free webinar that goes through these functions: Redesigned Reports with Grouping and Summary Functions
Cheers,
Genevieve
Answers
-
How do you have your sheet set up to track the data currently? Depending on how you have things, you might end up needing to have some helper columns to do what you want to do.
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
-
I have date columns as 5/31/23 columns as well as month/year columns 5 2023
-
Hey @TPALJA
What about creating a Report? Then you can Filter by if the Projects say "Complete", then Group by the Year column, add a second-level Grouping for the Month column, and use Summarize to COUNT how many rows are in each Group.
Here's a free webinar that goes through these functions: Redesigned Reports with Grouping and Summary Functions
Cheers,
Genevieve
-
thanks for the tip on reporting. I cant seem to get it to appear correctly on the dashboard.
I had created a formula for total # of jobs per month and a formula for those that are completed in separate reports. I was hoping to combined the two formulas, I tried to combine the two formulas but its not quite working for me.
=COUNTIF({Lead Follow Up Range 2 Assigned to}, IFERROR(MONTH(@cell), 0) = 1)
=COUNTIF({Job Status}, "Completed")
-
Hi @TPALJA
To combine two COUNTIF statements, you'll want to use COUNTIFS, plural.
Try this:
=COUNTIFS({Lead Follow Up Range 2 Assigned to}, IFERROR(MONTH(@cell), 0) = 1, {Job Status}, "Completed")
Cheers,
Genevieve
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!