-
Dashboard - Formula help for date fields
Hi I have a column in my sheet that is date specific. I am trying to bunch together how many actions have taken place within each month. E.g. if I have 5 actions, one per line, that have been executed within the month of May (all different dates) please can someone provide the formula that will allow me to make a count of…
-
Multiple IF/AND statements
I am a new user and struggling with some IF statement rules to set color status. For the most part, I am pulling from the status column called “Capability - Stage Gate Status”. Users choose from a drop list. In addition, I wanted to add some criteria for other scenarios, such as the Start Date is past and % is 0%; the…
-
Identify Duplicates with 2 criteria
Hello, I am trying to flag duplicates that meet 2 criteria. I have a sheet that has Request type actions (Add, Revise, Delete, etc.) and also a Part ID column. I am trying to identify duplicate Part ID that also have the same Request type. See screenshot. Ex: Row 1 and 4 should flag as duplicates as they are the same part…
-
Invalid Value Error with New Year
Hello! I have created a formula for 4 months after a specified date column. The problem is, when that 4 months goes into next year, I receive the "#INVALID VALUE" error. For example, if my formula is using the date of 08/31/19, I receive the proper formulated response of 12/31/19...but if I change the date to 09/01/19, I…
-
At Risk Flag Formula
I have tried searching and figuring out what my formula should be, but I just can't get it. I want my flag to be red when there are 3 days or less to due date. Frustrated. See screenshot.
-
Calculate the MEDIAN and MODE from a list of numbers
Hi there Does anyone know the formula to caluculate the following (based on a list of numbers within a cell range)? MEDIAN - The middle number when the numbers are put in order MODE - Most frequently occuring number Thanks in advance Phil
-
Summing IF and After 7
Hello, So I don't even know if this is something I can get a formula to do, but I am trying to get a number to check a cell reference and start summing if the number is above 7. But here's the kicker, I don't want it to sum the entire amount. I want it to essentially sum the number, minus that 7, but only sum the numbers…
-
Duplicates
How do i create a formula that shows there are duplicates. I would like it to have a check box in a column showing that "Sarah Jensen" has duplicate expense submission based off Consultant Name, Date of Receipt,Total Expense.
-
nesting If. Can't figure out why I get unparseable error
Here is my formula. It is in a project plan: =IF(TODAY() > [End date]1, [% Complete]1 < 100%, "At Risk", "On Time")
-
Help With Getting a IF statement to work when using columns referenced from another sheet
Hello all, I have a sheet that I'm trying to get the elapsed time in days from when a ticket was open to when it was closed. I am doing this using a second sheet, so the formula uses sheet references. I am having trouble getting this to work when using a range of items. When I use the COUNTIFS function, using areferenced…