-
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β¦
-
Counting Cells with "This but not that" Critera
Can anyone help me craft an formula that allows me to count all cells that meet certain criteria but not others? Example: Count all calls where the "Valid Phone Number" is checked, but the "Confirmed to Start" is unchecked. Thanks in advance
-
How to count on another sheet how many terminated employees per month?
Hello, I am trying to use the following formula in another sheet to count how many employees were terminated on the system per month: =COUNTIFS({Status}, @cell = "terminated", Month@row, {Turnover per month 2021 Range 4}, Year@row, {Turnover per month 2021 Range 2}) What am I doing wrong?