-
ISO - Simple At Risk Formula
Hi Friends, Looking for AT RISK Formula - I'd like a formula that says IF Start Date is less than today (in the past) and Status ISBLANK then AT RISK flag is flagged. Below is a completely wrong formula - I just don't know how to get the ISBLANK in there. Can anyone help? Formula challenged but love learning!…
-
Formula to return fraction that represents the number of cells that meet certain criteria
I'd like to return a fraction such as 3/4 to show the number of cells that meet certain criteria. If it returned 3/4 that would mean 3 out of 4 cells met the criteria. Currently, I'm using a percentage rating, but in my opinion, if you don't have at least 10 cells to evaluate, the percentage rating value isn't true in the…
-
formula - Time
I have a sheet with an auto Created date & time column AND a modified date & time column. Is there a way to create a formula column that will show Modified Date Time (minus) Create Date Time?
-
Can I make my status column read both the line above it and the column next to it using a formula?
I've been doing some research on IF, AND, OR equations to try and automate my sheet. Is there a formula that I can plug into the cell highlighted in the image above that reads not only the Status of the line item above it, but the Complete column at the row level as well? I would like for an artist to come in, check off…
-
How to check if a column has a value on a certain row with matching cell?
Hi, I have two sheets, Allocations & Installations. Once an Allocation is approved, the row gets copied to Installation. When the Installation is completed it is marked as such on the same sheet. I would like to automatically have it marked on Allocation as well. They share a [Shop ID] cell. So i need to check from…
-
Reports: Providing $ totals for only new entries
Hello- I've developed a sheet that tracks new registrations, with info like name, program, registration cost, revenue totals, etc. I want to create a weekly report that includes any new entries added to the sheet since the last report, but also to include the total financial sum of those new entries on the sheet. If I…
-
Another status light formula question
Hello all, I'm having trouble with my status light formula. I have the following columns: Date Due % Complete Status (red/yellow/green/gray) This is my current status formula: =IF(OR(ISBLANK([% Complete]@row), ISBLANK([Date Due]@row)), "Gray", IF(AND([% Complete]@row < 1, TODAY() > [Date Due]@row), "Red", IF(AND([%…
-
End Date is auto-filled, how to stop?
Hi All, I have created a sheet for my team and outside of normal columns, we have an extra "Target End Date" to track if we meet target or not. Please see picture. However, the Actual End Date is auto-filled every time I enter Start Date with the default value of the same day as Start Date. It is very inconvenient, I am…
-
Converting a formula to a "column formula"
I am trying to convert this formula into a column formula. It takes selected cells from a row to populate the overall "Status" column. If tasks are "Not Started", the overall status will be "Not Started". The Same would apply for Cancelled. If all tasks are complete, cancelled or n/a, the overall status would be "n/a". If…
-
Parent/Children formula help.
Hi! I am wondering if someone can help me with a formula? I have a parent row with multiple children row underneath. I have a column with checkboxes to be marked when the task is completed. After all children rows tasks are completed, I want the parent row checkbox to become checked. Is this possible?