Formula Not Working
Hello,
I have a formula I am using on multiple reports, to pull data into a dashboard. The formula worked on the first two sheets, however it is not working on the third one and I am not able to figure out what I am doing wrong. I have included a screenshot of the formula, a screenshot of a sheet where the formula works, and the data source. We are trying to count the amount of reports received after the end of the month.
Thank you,
Cara
Answers
-
You aren't just copying and pasting the formula into the 3rd sheet right?
The references won't work on a new sheet you need to redo the reference for each sheet.
-
Are you getting an error message or an unexpected number?
-
Hi Paul,
Unexpected number, so for instance in the first column it should return a 2 for the report being received later than the date expected, however, it is returning 0.
Thanks!
-
Hi Mike,
Correct, I am not copying and pasting, I am redoing each formula.
Thanks!
-
Try replacing the second range with @cell.
=COUNTIFS({Range}, @cell >= DATE(.....))
If that does not work, make sure the column being referenced is in fact set as a date type column and the data in the column is actual dates.
-
Morning @Paul Newcome !
So the individual who originally created the sheet did some investigating and identified that he did not have the columns set as date columns as you stated above.
Thanks for all your help!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!