Welcome!

Invalid Data Type - Date Column Sourced

Hi All,

I created a metric sheet for my Dashboard with a section to count how many ground breaks I will have in 2024. The formula is sourcing a date column in my Summary Sheet.

I entered the following formula into my cell:

=COUNTIF({Summary Sheet Range 2}, YEAR(@cell) = 2024)

Any ideas on why it's throwing an invalid data type error? Both columns are Text/Number.

Thanks for your help!

Find more posts tagged with

Comments

There are no comments yet

Sign in to join the conversation!

Quick Links

Trending discussions

Formula to check a box based on criteria
Hello , I am looking for help to write a formula that will check a box if certain criteria are met. I have students that are signing up for a class and they need the previous class or classes as prerequisites. for example i have class 1, class 2 , class 3 and class 4. each higher number class needs to have completed the…
Min Collect Help - date returning zero value
Hello, I am looking for formula help where I want to return the earliest date in a range for different workstreams groups on a project. The source sheet is formatted as a date field, and the formula used below is returning a 0 no matter what I do. Any suggestions? =MIN(COLLECT({Project Plan - start date}, {Project Plan…
Distinct values from multiple sheets
I currently have 14 sheets with the following columns: Batch # and Reviewer I use an Index Distinct formula to acquire the unique batch numbers from all 14 sheets and put them into 14 columns on the 'metrics' sheet. I then use another index distinct to get a list of all the unique batch numbers into one 'Unique Batch…