-
(Count if) And & Or
I need a formula that will count the number of rows with High priority and are New OR Open. I cannot figure this out, so any help is appreciated!
-
Nested OR function within and AND logical statement
Hello, I am trying to have the following into a single logic statement: IF Nucleotide Category is "Labeled" AND Characterization Status is "Characterized" AND QC Status is either "Pending" OR "Incomplete" =IF(AND(Nucleotide Category]@row = "labeled", [Characterization Status]@row="Characterized", (OR([QC…
-
Formula for referencing two columns in another sheet.
Hello, I would like to add a formula for the partners' cell(image #1) to reference the two columns in another sheet (image #2). The current formula you see in the first image only references the Partners(existing) column. Any help is deeply appreciated!
-
Countifs after a date
I am trying to count the number of closed opportunities for the 2021 calendar year that meet the criteria of: Won AND is of market sector offices new. I have used the formula below but it's not working. Where have I gone wrong? =COUNTIFS({Sheet - Sales Pipeline Sales Stage}, "Closed Won", {Sheet - Closed Opps Market…
-
Need a formula for Calculating the average for % Complete Column.
-
Tried this one it says UNPARSEABLE??
=INDEX({Description List}, MATCH([Description]@row,{TGS Part Number},0))
-
Missing IF?
I am using the following formula to return the oldest (no of days) unanswered question type of 'alterntaive proposal' =MAX(COLLECT({Days since submission}, {Question Answered}, 0), {Submission}, "alternative proposal") However, it returns the oldest of all question type alterntive proposal so answered and unanswered. makes…
-
Rank Top 20 Clients By Value of Won Opportunities
We have a sheet we use to track opportunities. I'm trying to figure out a formula to create a list of top clients by the value of won opportunities in a metrics sheet so that I can add the list to a dashboard. Above is an example of the data. The list of clients changes so the formula needs to by dynamic. I want to show…
-
Stumped on combining AND/IF/OR formula
I need a formula where if Innovate Audit is Yes, or Innovate Audit Upgrade is Yes, but Pull Print is No, then the the # of devices requiring in printer agent/40 +1 Here is what I came up with so far... =IF(OR([Innovate Audit]@row = "Yes", [Innovate Audit Included in Upgrade?]@row = "Yes"), IF(AND([HP Advance Pull…
-
Counting Concurrent Jobs
Each row in this spreadsheet is a "Job". I'm trying to count (project the count by month) concurrent "Active" jobs (rows) based on a start and finish date of the job. I created two columns (per 12 months) to set the criteria for each months calculation. If the monthly criteria falls between the start and finish dates of…