-
Aging Date Reporting
I used this formula for reporting aging days from a specific date (8/1/2022) with the range the date the item was created. I need to report aging from "current date" to the create date. Is there a way for the system to automatically calculate from the current date? =COUNTIFS({TJ Regional Health eService Range 6},…
-
Cross-sheet formula for conditional sum of column
I am trying to create a formula that calculates that sum of a column from a different sheet. Conditions are that the column for PM name of the referenced sheet must match the PM name for this row. (trying to calculate this sum for multiple PM names) The column I am attempting to sum from the referenced sheet contains a…
-
Count how many in one multi select column
I have an OLIT Training Column that is of multi-select dropdown type. The column is tracking who has done training on what software. I would like to get a simple count how many specific software item are in the column range. I am using the following so far but it only counts if there is only one selection in a cell, it…
-
Hi, Can someone help me with using @row within my COUNTIFS formula?
The formula I'm using is: =COUNTIFS({OKS Satellite Accumulation Area Inspection Range 3}, "A-1", {OKS Satellite Accumulation Area Inspection Range 5}, "No") For some reason, when I add @row to both ranges, it comes back as unparseable Thanks
-
Substitute / or
=SUBSTITUTE([CASE 1]@row, ",", CHAR(10)) Sometimes in the Case 1 cell, staff will enter ex 1, 2 or 1 - 2. How would I add a or to substitute either of the scenarios. Thanks
-
Project health formula based on due date
I want to create a project health formula that accomplishes the following: If target end date is >3 days, status is complete, or target end date is blank = green If target end date is in 1-3 days and status is not complete = yellow If target end date is today or 1+ days ago and status is not complete = red
-
Counting the date range inside/between two columns?
I'm creating a sheet with one project on each row. Projects have start dates and end dates etc. As the same persons will be working on several similar projects simultaneously, I'd need to be able to calculate the date range (number of days) from the earliest date to the latest date to be able to determine the total number…
-
Using vlookup with IFERROR and NOT ISBLANK
Hi guys and girls, Scenario. I would like to populate a cell on Sheet A from a vlookup on Sheet B. - This works. I moved onto if the cell on Sheet B is empty DO not apply #NOMATCH to Sheet A and make a text comment e.g. No record. - This works with IFERROR =IFERROR(VLOOKUP([header1]@row, {Sheet B Range 1}, 4, false), "No…
-
Problem with INVALID DATA TYPE error with COUNTIF formula
Hello, I am trying to capture all entries where my delay (calculated using NETDAYS formula) is bigger than 50, using COUNTIF, and getting an INVALID DATA TYPE error. I tried many things, including making sure the dates used to calculate the delay ARE proper dates. I am stuck. The strangest thing is I used to had this…
-
Limit access to hierarchy
Hi I have this hierarchy function in my sheet and wanted to only share certain rows with certain people. I do not want everyone to be able to access the whole sheet. Is there a way to do this? Thank you !