COUNTIFS with Checkboxes and between Date Range
Hi everyone!
So I need help again and hoping someone would be so kind as to help me. I need a COUNTIFS formula that will count the number of checkboxes checked, if a date column is in a certain month. I have found out to count the number of actions by month, but because of different criteria I need to count the checkboxes and have it go into sheet that shows XXX actions were complete in February 2023. Can anyone help me? Below is what we are working with so far. {CY23 eQIP Station - Background Investigati Range 1} ,1) is a checkbox column and {CY23 Intake Station - Personnel Security I Range 3} is a date column.
=COUNTIFS({CY23 eQIP Station - Background Investigati Range 1} ,1), {CY23 Intake Station - Personnel Security I Range 3}, IFERROR(MONTH(@cell), 0) = 2, {CY23 Intake Station - Personnel Security I Range 3}, IFERROR(YEAR(@cell), 0) = 2023)
Best Answers
-
Hi @Peppey, you should start naming your ranges a bit more intuitively -- you're using the default range names. I always use the general naming convention "AbbreviatedSheetName_ColumnName", so I would name yours something like: "CY23_CheckBox", "CY23_Date" -- this way you won't go crazy when you have to come back and fix things. I would just simplify your date range using the DATE function:
=COUNTIFS({CY23_Checkbox}, 1, {CY23_Date}, @cell>=DATE(2023,02,01), {CY23_Date}, @cell<=DATE(2023,02,28))
Let me know if this helps, and please flag this post if I answered your question! Good luck!
-
Hi @Peppey glad it worked!
Answers
-
Hi @Peppey, you should start naming your ranges a bit more intuitively -- you're using the default range names. I always use the general naming convention "AbbreviatedSheetName_ColumnName", so I would name yours something like: "CY23_CheckBox", "CY23_Date" -- this way you won't go crazy when you have to come back and fix things. I would just simplify your date range using the DATE function:
=COUNTIFS({CY23_Checkbox}, 1, {CY23_Date}, @cell>=DATE(2023,02,01), {CY23_Date}, @cell<=DATE(2023,02,28))
Let me know if this helps, and please flag this post if I answered your question! Good luck!
-
Hi Lucas! This worked perfectly. I cannot believe I didn't do the same formula you provided me before. Thank you so much!
-
Hi @Peppey glad it worked!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!