Counting by Number of files scheduled to go live EACH month. Creating a smartsheet summary.
I have a Target Complete Date for each type of file (over 1600)
I need to capture the number of files Due to complete in Jan, Feb, etc
Each month. I need to report each month on a summary report separately.
Below I am trying to count IF any Applied Bank Files are due to complete in January. The first off sheet reference is the file name column, the second off sheet reference is the Due to Complete date column.
=COUNTIFS({Remitco FIle Range 3},"Applied Bank',{Remitco FIle Range 4},>=DATE(2020,01,01),AND<=DATE(2020,01,31))
Best Answer
-
Try this...
=COUNTIFS({Remitco FIle Range 3}, "Applied Bank", {Remitco FIle Range 4}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2020))
Answers
-
Try this...
=COUNTIFS({Remitco FIle Range 3}, "Applied Bank", {Remitco FIle Range 4}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2020))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.2K Get Help
- 386 Global Discussions
- 212 Industry Talk
- 445 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 292 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!