-
RYG Change Based on Moving Variable
Hi, all. I was looking to write a formula that would change a RYG based on if the project was still on track for the determined amount of time. It would start green and if the project was projecting as running longer than anticipated would change to yellow and then red when it went over a further threshold(of say %7 of the…
-
Automated RYG ball issues
I have a sheet where I am using red, yellow, green and gray balls to indicate project health. If the project is complete, the ball is gray. If the due-date is within the next 14 days, yellow. If due-date is today or in the past, red, and everything else green. I must have something wrong somewhere, because the red isn't…
-
Index Match with some data returning as Invalid Data Type
I'm using an Index match to pull a certain number. In this column I will get a successful return of a few number then the Error then more correct numbers. Thing is, they are all pulling from the same data set (from an API), and using the same parameters and search values. Why am I getting the Invalid Data Type error?
-
Created (date) format in formuals
When using the COUNTIFS formula and referencing the created (date) column in another sheet, what date / time format do I need to use when including a specific date as criterion?
-
Formulas
I have a formula that is working in most of the cells. However the number is not showing and the formula is in the cell. I am not sure as to why it is not showing up with a value. Here is a copy of the formula. =IF([project name]1 = "", "", IF([PanAm proposal needed by]1 = "", JOIN("it's been ", TODAY() - [quote request by…
-
Open-ended column on another sheet
I am using SUM referencing a column on another sheet and I want to get that column to be Open-Ended (so that when new rows are added to the other sheet, they will be automatically be in the new total on my sheet). Details: I am adding Hours from a time card sheet. When I stay on the that time-card sheet, Open-ended is easy…
-
#UNPARSEABLE Formula
I am trying to get this formula to work correctly in final calculations of a project we are working on. =IF([Column3]2="","",IF([Column17]2="",CONCATENATE("it's been ",TODAY()-[Column5]2," days"),IF([Column17]2-[Column16]2<0,CONCATENATE(-([Column17]2-[Column16]2)," days to spare"),CONCATENATE([Column17]2-[Column5]2," days…
-
Help on formula: Nested ifs
Hi, Please need your help on the below formula. As you can see on the image below, the stage column is set up as a dropdown list. I wanted to get a formula that says, if the project owner decided to close the project at a certain stage (these are the subtasks) because of any of the listed reasons, it will be reflected in…
-
IF Function
I want to create an IF condition where if a cell contains a symbol on another sheet that equals "New" then populate that value otherwise, leave it blank. I have this formula: =IF({New Applicant(s) Range 1} = "New", {New Applicant(s) Range 2}) According to what I've read in the HELP, the False condition is optional and if…
-
Tracking latest Changes for Helper Column
Hey all I need some help with tracking the latest changes in a row for my sheet. My sheet is going to have repeating update requests to track each shifts production levels every couple hours. The team leaders will update the row with the current production number at every interval. I want to have a helper column that will…