Sign in to join the conversation:
Is there a formula that would count the number of cells where a Done check is not completed but only when another columns due date is in the past?
The goal is to count how many past due tasks I have. Does anyone know the best way to accomplish this?
=countifs([Done Check Column Name]:[Done Check Column Name], 0, [Due Date Column Name]:[Due Date Column Name], >Today())
Should give you a count of everything that is not checked and is in the past.
I can't quite get the filter to align with my intent. I'm either pulling every status when I want to exclude "Complete" tasks or I can't get parent rows for my project schedule. I want the attached report to do the following for ease of presentation past due AND upcoming activities. Status is one of Not Started or In…
I am trying to find the right formula to use in the scenario if a cell in the row is yes, then it sums cells in the same row to create a total. threshold totalscore1 totalscore2 totalscore3 Final score yes 46 10 9 this would pull a total for the 3 total score cells in the row no 15 75 12 this cell would not total because…
Hello! I'm currently creating formulas for a gift register to document the price ranges we have and how many are in each category. My categories are: £0 - £50 £50 - £100 £100 - £200 £200 + However, the formulas aren't pulling back all the data accurately because some of the cells include text too like 'less than £500' or…
