-
Identify Row with Most Recent Date for a Value with Fewer Cell References
I have a sheet that has reached the cell reference limit and won't allow other sheets to copy rows into it. After doing some research it seems that my column references (column:column) within my formulas are the problem. My sheet contains a unique identifier in the column "ID", and there is a reported date column (we are…
-
Index/Match working for some of the entries, but not all
Hello, I have a list of LMS students who register via form. When a student registers, I have an Index/Match on both the last name of the person and the email address and compare it to my master list. If they both exist, a number appears in the Current In System column. If not, it says #NO MATCH. Here's the issue, all these…
-
#Date Expected Error
Hi, I have 2 sheets - 1 is for active projects and the other is for completed. They both have the same columns. One the active sheet my month helper formula =IFERROR(MONTH([Date Update Request]@row), 0) works perfectly. On the completed sheet, it returns a #DATE EXPECTED error. The columns are all date columns. Any ideas?
-
Calendar View - Dates in multiple columns within the same row
I see old responses to this question but nothing recent thought I thought I would ask. I have a spreadsheet with dates in multiple columns. They may not be consecutive so I can't use the range function. Is there any way to show each date as an individual date on the calendar? I tried to make each column its own sheet by…
-
Metric sheet used for Dashboard not updating correctly
I have been using this feature for a while now and I have been relying on refreshing the metric sheet manually but I think there should be a better way to have this done. I have two issues - one is with a countdown formula where I am using the Today function. Unless I open this sheet, the formula does not get updated…
-
Combining Multiple IF AND Statements
Hello, I am trying to combine the 3 statements into one. They all work independently however, I am missing something when I try to combine them. These each check a checkbox if the statement is true. Help Please! =IF(AND([Trans date falls w/in Black-out Period]@row = 1, [Covered Person?]@row = "Yes"), 1, 0) =IF(AND([Covered…
-
Confusion With Using Comparison Operators on Dates
I want to use conditions to mark rows where the date is within the past 30 days, in just trying to test this out I made a column of properly formatted dates and am referencing them in an IF formula: =IF(Date@row > TODAY(-30), "True", "False") Today's date is 4/20/2023 so TODAY(-30) returns 03/21/23. When Date@row =…
-
COUNTIFS with CHILDREN Function and Multiple Criteria
I am trying to achieve the following a % Completion Formula using the following column: "Availability Status". Availability Status has the following drop down: "Available" , "Unavailable - In Progress" , "Unavailable - Backlog" I want to COUNTIFS the number of child rows that have "Available" and "Unavailable - In…
-
COUNTIFS and Duplicate Values
Hello! I need to figure out a way count the number of records in my issue log, EXCEPT if the records have the same parent number, they can only be counted once. Is there an easy way to do this? Is there a way to use the DISTINCT formula in the "Parent" column, but also count the blank rows, as long as the Record column…
-
How to populate data based on drop down value of another cell.
Hello everyone, I am new to SS and struggling to get a fix on what I am trying to achieve. Would appreciate any help, thanks in advance! I am trying to populate the Script number, issue line and responsible party (all separate columns in the parent sheet) in a different sheet (calculation sheet) only when the execution…
