Countif the Year 2021 on a Column Returns #invalid data type or zero.

heyjay

heyjay ✭✭✭✭✭

09/23/21 in Formulas and Functions

https://app.smartsheet.com/sheets/xXvWq9JrWMjRXGHv7jcV4Q4GF45wJWc4C32GcHw1

...

Tags:

0 ·

Best Answer

MCorbin Overachievers Alumni

09/23/21 Answer ✓

Try this:
=COUNTIF(Date1:Date11, YEAR(@cell) = 2021)

1 · Share on Facebook Share on Twitter

Answers

MCorbin Overachievers Alumni

09/23/21 Answer ✓

Try this:
=COUNTIF(Date1:Date11, YEAR(@cell) = 2021)

1 · Share on Facebook Share on Twitter
heyjay ✭✭✭✭✭

09/24/21

https://community.smartsheet.com/discussion/comment/305949#Comment_305949

Thank you, it worked. didnt know it needs @cell code. This is my first time seeing this one. Need to read the documentation.

...
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Importing Excel Files
Hi All! Does anyone know why sometimes it shows " ' " in a cell when an excel file is imported? I´m having a hard time when it happens because VLOOKUP formula cannot find the information ... Thank you & Regards, Camila
Retrieving parts of a text fields
Hi there, I have a project identifier column that includes a project code (111-AAA) and project name (client name). Ex: 123-ABC Disney Corp I would like to separate the Project Code and Project Name into 2 Columns, which will result in me having 3 columns Project Identifier, Project Code and Project Name. For the 'Project…
How can I tick a box based on two criteria?
I'd like to tick a checkbox based on another checkbox being ticked and for a specific task name. I have the following formulas that work individually. How can I combine them? =IF([Checkbox]@row = 1, 1,0) =IF([Task name]@row = "XYZ", 1,0)