-
If/then question with color formatting
This is what I am trying to accomplish. Is there a way through conditional formatting or any other options If [Report Submission Date] is greater than [Report Due-10] then Report Past Due Flag should be RED If [Report Due Date-10] is in the past AND [Report Submission Date] is blank, then Report Past Due Flag should be BLUE
-
Automating Date fill in other than Today?
I am trying to figure out if it is possible to use the automation function to essentially say, "when column A is filled in, mark in column B Today + 1." I'm not sure this is possible, but I wonder if anyone has been able to accomplish anything similar with the automation function. I specifically need this to be an…
-
Count if columns is not empty and the range is within the date range
Im trying to make a formula work. My logic is to count the number of cells which the projectmanagers column is not blank and the projectmanagers row is edited in the last 7 days. This is the formula im using but it keeps returning "#INCORRECT ARGUMENT SET" any idea on what could I be doing wrong? Any help is appreciated.…
-
Automatic Project Phase Formula
Hello, I am wanting a formula that returns the current project phase. The phases include Initiation ,Planning, Execution, Testing, Implement, and Closing. I want the formula to return the text value of the phase that has the least % started, NOT including phases at 0% or at 99% and higher. In the example below, I would…
-
#Invalid Operation Error with dates
I'm trying to write an IF formula to identify whenever a date is in the past with a "Yes" or "No" response. I have tried 2 techniques. Technique 1: =IF([End Date]@row<TODAY(),"Yes","No") - result is #Invalid Operation Technique 2: created a second column filled with =TODAY(). Then, I tried: =IF([End Date]@row<[Today's…
-
COUNTIFS, Dates + 7, Checkbox Unchecked
Each day, I want to create a running total of unchecked checkboxes for today and the previous 7 days. For this sheet, I need a Countifs, that will count from the date column and the previous 7 days of unchecked boxes for each column. It will be a total of unchecked boxes for all columns for today + the previous 7 days.…
-
Average/Roll Up Harvey Ball % Complete Symbol in Parent Row
Hello, I have a feeling this is going to be so simple, but I cannot seem to figure out how to average the values of the Harvey Ball % Complete symbol in a parent row. Per my screenshot, I want the Harvey Ball with the red arrow to average the values of the Harvey Balls beneath it. There is a parent/child relationship…
-
Get total cost based on multi select
Hi everyone, I have a total column that I want populated with a dollar amount. I want this to be dependant on the specific services selected from a multi select. The trick here is that the services rendered are completed by different vendors with different prices. So, the multi select prices will change based on the…
-
Vlook up is not providing the correct answer
I am using VlookUP to bring the % complete amount from my Banya Project Management Sheet into my Banyaterza Sister Project Plan work sheet. The formula is working for two of the cells which I have highlighted in yellow, but for other cells it is giving the wrong response? The formula used on the Banyatereza Sister Project…
-
Symbols and formulas
I have a sheet that has 4 dates on it that I want to use symbols for completion purposes but I cannot figure out the formula or if it is even possible. I am trying to use the status bar with Empty, Quarter, Half, Three Quarter and Full. Here is what I would like to happen. If Date 1-4 are greater than today I want it to…
