-
Formula to count days past due but leave the column blank if the task is completed
Hello, On my sheet I have tasks that have a column for Due Date, Completion Date, and Checkbox for Done. I want to keep track of the tasks that are overdue and have an easy way to glance and see how many days they are over due from the due date. I have been successful in using this formula for that calculation =TODAY() -…
-
COUNTIF Excluding one Status
Hi, Please consider this below table as a scenario where while that I am counting the HR Type against Solution Type if the COUNTIFS formulae, I simply want to exclude "Complete" ones Below if the formulae that works without the project Status condition. How do I exclude for Complete =COUNTIF({HR Category},"B",{Solution…
-
Automation for Updating Metrics Data on Dashboard
I have data that rolls up into a Metrics sheet. I currently have metrics, by month, displaying on my dashboard The data is currently manually update, by month. Is there a way to automate the change in month, subsequently updating the data displayed, i.e. volumes?
-
Countifs and Isblank is not working
I am using a formula in a column, "Repeat Values" that checks another column, "Document Number", for repeat values and if there are repeat values it checks the checkbox in the "Repeat Values" column. This formula is somewhat working, but also checks the box for all blank cells in the "Document Number" column.…
-
countifs issues
=COUNTIFS({Incident Summary Form Range 1}, "Sioux City", {Division}, "utility", {Incident Summary Form Range 8}, AND(@cell >= DATE(2021, 1, 1), @cell <= DATE(2021, 1, 31))) This worked until i added {Division}, "utility", can someone tell me what i did
-
Identify deliverable date at the parent level
I'm using these formulas to show the next milestone date: Milestone checkbox column: =IF([Expected Finish*]@row = MIN(COLLECT([Expected Finish*]:[Expected Finish*], [Expected Finish*]:[Expected Finish*], >=TODAY())), 1, 0) Next Milestone Date: =MIN(COLLECT([Expected Finish*]:[Expected Finish*], Milestone:Milestone, 1))…
-
Countifs Question
HI I am trying to do a Countifs using the below, the result keeps coming back as 0 but I think that is because the box only has either Pass or Fail in it but not both in the same cell, I am trying to add up all Pass and Fail Inspections, how do I include both Pass and Fail results. =COUNTIFS([Building Unit]:[Building…
-
SUMIF - Referencing another sheet
I'm trying to sum based on certain Streams(column name) in another sheet 'Register' Stream data is as: Emergency Youth The formula I've used is: =SUMIF({Register Range 3}:{Register Range 3}:, "Emergency") I'm getting an unparseable error Please help!
-
Returning the most recent value that matches multiple criteria (cross-sheet lookup)
Hi All, I am trying to create a preventative maintenance schedule for our fleet vehicles and heavy equipment machines based on the vehicle/machine, the most recent odometer readings or machine hours, and the type of service needed (PM Service 2, PM Service 3, Oil Change, etc.). For my source sheet, I'm using a repair and…
-
Count If from Roll Up
Hi all, I am trying to count the number of occurrences of certain keywords from a sheet column into a rollup. I cannot seem to get the formulas right. Error coming up as #UNPARSEABLE Keyword "HHS", Sheet Name "25", Column Name "Funding Agency" =COUNTIF({25 Range 1}[Funding Agency]:[Funding Agency], "HHS") A little…
