-
IF formula and dates: 'Red' status if the % complete is not 100% and the date is in the past
Hi there, Is it possible to incorporate dates in an IF formula? Essentially I want the RAG status to automatically go to 'Red' if the %complete is not 100% and the date is in the past - how would I go about doing this? Thank you
-
COUNTIFS function with two criteria
Hi all! I'm currently trying to count how many red entries (in the "Puri Safety" column) are in the month of June (using the "Created" column). I'm trying to use the following formula: =COUNTIFS(Created:Created, IFERROR(MONTH(@cell), 0) = 6, [Puri Safety]:[Puri Safety], "Red") However, it returns a value of zero... what…
-
How do I calculate an expiration date from a specific date column
I want to use the date in Column A plus "X" months so that Column B populates a new future date. What's the syntax I can copy/paste into Column B? Example - Column A (Contract Effective Date) - 5/29/2020 Column B (Contract Expires on Date) in 4 month. Should = 9/29/2020 ***"X" months can change as it may not be the same…
-
Formula needed - adding total of one column dependent on other columns criteria
I need the sum of one column conditional to the criteria of 3 other columns; below is the formula I am attempting to use with the goal of obtaining the sum of [% KRs Contribute to Corp Objs] that have the below additional columns criteria. Can anyone review and let me know if I need a different formula or what I am…
-
How to include Paranthesis in formula.
I am using an IF formula in a Total column Column A A) Option 1 B) Option 2 Total Column = IF ([Column A]@row = "A) Option 1" , "3", IF([Column A]@row = "B) Option 2" , "5")) I am getting error, as ) is prematurely closing out the computation. Any help is much appreciated. Thank you, Deepthi
-
Complex COUNTIFS and IF Function
Hello, I need help putting together a function that can count certain cells in my grid. The inputs of the function are the following: If Beta is "Yes", it should be counted twice If Beta is "No", it should be counted once But if the Primary Region Column is not checked, the row should not be counted at all. Beta is a…
-
Need to Count Unique Values Based on Criteria from a DropDown Collumn
Hello, I need a function that can identity duplicates and determine if they should be counted as one or more than one depending on criteria within another column of the spreadsheet that is a dropdown. The specific context is there is a Name Column (Column A) and a Dropdown Column (Column B), Column B has three options "Yes…
-
Help with RYG IF Statement and consider a Blank Cell
I have a sheet to measure KPI's for a project. Bascially I'm trying to record when we submit a report; If the Submission Date falls before the 4 Week Limit (Purple Helper Column) KPI 2 returns Green If the Submission Date lands after the 4 week limit but less than 14 days 'late' KPI 2 returns Yellow If the Submissinon Date…
-
#BLOCKED on Dashboards
Hi Community! I have built a data visualization dashboard that runs off a "summary" sheet. The summary sheet is all formulas that average data from a master sheet. My problem is, instead of the Dashboard updating live based on the data in the summary sheet, it breaks and shows #BLOCKED every time the master sheet updates.…
-
INDEX from another sheet's multi-contact column
Hi, I have a "Project Master" sheet that lists all our projects and has a multi-contact column where I keep all the resources (contacts) that are working on each project. On a set of other sheets, I am trying to collect and index the set of projects to which a single resource is assigned (and I need that to be a metric…