COUNTIFS Status and Year is Current(Cross-Sheet Formula)
![Protonsponge](https://us.v-cdn.net/6031209/uploads/userpics/OMNDRH3JYR6E/nXO1DJELW52G4.png)
Hello Community…
Stuck trying to work out a COUNTIFS formula for Status is X and Year from a date column is current year,
The first part I have…
=COUNTIFS({Status}, "Pending Submission",
The second part I am looking for help in this the {Submission Date} which is currently a date column is the current YEAR.
I have this working with the use of a helper column as per below but wanted to know if this be achieved without a helper column to extract the year?
=COUNTIFS({Status}, "Pending Submission", {Helper Column-Submission Year}, YEAR(TODAY()), {Another field}, 0)
Grateful for any help/advice,
Protonsponge
Best Answer
-
Give this a try:
=COUNTIFS({Status}, "Pending Submission", {Submission Date}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))
Answers
-
Give this a try:
=COUNTIFS({Status}, "Pending Submission", {Submission Date}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))
-
Thank you @Carson Penticuff, that worked perfectly - very thankful for your insight!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 36 Webinars
- 7.3K Forum Archives