-
Formula linking one column to another sheet; =IF(ISBLANK) function
Hi all! I need some assistance in creating a formula that links a column in my first sheet (Health Records) to a formula that is in another sheet. In this second sheet I hope to use the =IF(BLANK) function to display whether these records are "Complete" or if left blank in sheet one, "Incomplete". I have tried using the…
-
Why does the INDEX/MATCH formula return the same value for same value cells on different rows
I am using an INDEX/COLLECT Formula: =INDEX(COLLECT({IP}, {Site}, SIte@row, {Lane Number and Direction}, [Lane Number/Direction]@row), 1) This works great. Except for when the Lane Number/Direction is the same value in the rows. I have a several rows of Sites with the same value (BK-1-1E). The Lane Number/Direction is the…
-
Automation to turn cell red past due date
Hi! I'm trying to have the cell Actual Completion Date turn Red if it is past the Target Completion date. I didn't see anyway for this to happen with conditional formatting and am thinking it will require a Helper Column or a formula. I can't figure this out and need some help! Any suggestions?
-
Calculation Help - Project Traffic Light RGY Based on Due Date, % Completed and Status
Hello I need a calculation assist. Columns: Start, Due, Duration, % Completed, Status Status drop downs: Not Started, In Progress, Overdue, Completed. Need traffic light based on the following: Complete 100% = Blue Not Started 0% Complete Due Date Over 7 Days = Green Due Date Less than 5 Days = Yellow Due Date Less than 2…
-
Collecting Average Between 2 Ranges
Hi all! I am trying to collect an average over the last 12 rows (including the current row). To do this, I created 2 additional helper columns (Line-ID and Row#), and trying enclosing the condition in an AND clause, however this seems to return unparseable. I think I am on the right path or way of thinking here, but that…
-
Can you sort the card view cards horizontally?
The default view is pretty good when you dont have lots of cards, But I notice that when you get more than 10 or so cards you need to scroll to see the rest of them. Is there a way to have the columns display like rows instead?
-
Formula To Add Columns that Contain a Value
Hey All, I am creating a training matrix and need help with a formula for the "Total Trainings Completed" column. Each training (1,2,3,4, etc.) will be its own column and based on where the employee is at in the training a number value will be entered in that columns cell ( 0= not started, 1 = in process, 2= trained, 3 =…
-
Alert someone when $ value is approaching next increment of $50,000.00
I am creating a 'Project Tracker'; 1 location per row with many different columns one of the columns being '$ Spend to Date'. I need to notify program manager when '$ Spend to Date' is nearing $50,000.00, then again when '$ Spend to Date' is nearing $100,000.00, then again . . . $150,000.00, then again . . . until we reach…
-
Formula returning Invalid Column Value
Hello, I'm struggling with a formula that is returning an in valid column value error. All columns are Text/Number. Sheet 1 has one row for each project. Sheet 2 has a column that may have multiple project numbers in the same field. I need to return the value in the Status field (which is a drop down) if the project number…
-
IF, INDEX, MATCH formula help
I need to add an IF statement into an INDEX MATCH formula that pulls the system size of a column if it is not blank. This formula will be on sheet #1 and needs to be an IF, INDEX, MATCH. Sheet #2 will have the actual system size column and Sheet #3 will have the target system size column. The formula should pull from sheet…