Formual for summing/counting
I have a running sheet that tracks the date for a review. The basic sheet has Location, District, ReviewDate, Available_to_Review.
I need the column to be a calculated field that give me a Y/N or 1/0) for every record. The criteria would be if a Location has had a Review Date in the last 30 days, the Available_to_Review column would show N for every location in that district.
Ideally, it then updates the table like this because the last Review date 9/10 sets the Available for Review column for all Districts to 0.
This would allow me to create a Report that only shows Locations in Districts that have not had a review date within the last 30 days.
Currently my formula looks like this...
=(IF([Review Date]@row > TODAY(-30), COUNTIF(District:District, District@row), 0))
I get why this is giving me the results I have, but I am stumped on how to get the results I want...
Help Article Resources
Check out the Formula Handbook template!