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?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!