-
Multiple Criteria, total count
Hi All, I am trying to do calculate a total number of events, that match criteria for 1. Date range (can also use fiscal column as a matching criteria where i only want those that contain specific letter/numerical value = Q2) for all -NDA Webinars. I don't want it to count each column that matches the criteria, but if the…
-
Basic RAG Calculation formula based off completion % in project schedule
Hello All, I would like to know if anyone knows how to set up a basic RAG formula based on completion % and the schedule date. Custom criteria would be as follows: If % Complete = 100, return Blue If it's not scheduled to start yet, return Clear/Grey If past the scheduled finish date and % complete is less than 100%,…
-
Function for Calculating with Dropdown Boxes
Hello - We have a column that has a checkbox for each year, and another column with a numeric number in it (called Complexity Score (NUMERIC FIELD ONLY) on my screen print). If someone has January, March, April and Sept checked for months in the dropdown column, I need to calculate a the numeric number times how many…
-
Rolling average by week number
I'd like to automate the calculation of a rolling average: "Average the value of the past four weeks" "Average the value of the past 12 weeks" The 'SUP avg' column is what I want to average, and 'W#' is week number. I know we can get the current week number with =WEEKNUMBER(TODAY()) though I haven't figured out the rolling…
-
SUMIF Not Working
Hi, I'm running into issues when trying to use as SUMIF function in my sheet summary. I need to have it add together all the percentages in the red square under the column "Capacity Rating." The goal is to be able to create a SUMIF for each project manager in the division so we can see what their workload capacity is…
-
Count Function not working
Hello, I am using a COUNTIF function as shown in the screenshot attached, and it is grabbing the "Complete - Handover to VAR" Status field, but not the "ONB - No Reply by VAR" status field. There is some conditional formatting applied, but I'm not sure what the formulae isn't calculating the ONB - No Reply by VAR field.…
-
Move Row w/ Formulas
I have 3 sheets that are being used in tandem: Sheet 1 Registration Data Sheet 2 Travel Requests Sheet 3 Cancelled Registrations Sheet #1 has a "registration status" field (dropdown). This field is being pulled into Sheet #2 by using an Index/Match formula. If the registration status (on sheet 1) changes to cancelled, I…
-
Action based on System-Generated Modified Date/Time
Is there a forumla I can create that will check a box based on the auto-generated timestamp? Screenshot: I am looking to check the AM/PM box based on entry time (anything before 12PM would check the AM box and anything after 12PM would check the PM box).
-
Formula for Counting RYG by Child Row
Hello - I'm trying to add to a Dashboard. I need to see status by color for each child row. I also need a count by each child row (Admin, CPM, etc.). Help! Thank you.
-
AVERAGEIF or AVG ??????Why is this not working and how do i get it to work
So i basically want to calculate the average of all completed query. In the picture above there is a formula that calculates how long the task takes. If is not complete it does not have a data and the formula will show the #error above..... this i think is where i am going wrong i just dont know how to change it... Please…