-
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…
-
COUNTIFS referencing date ranges specified in Sheet Summary
I'm trying to count the number of cells (dates) that fall between two dates that are selected in sheet summary. In excel I've been able to make this work =COUNTIFS($C$7:$C$47,">="&$H$1,C7:C47,"<="&$H$2) H1 and H2 being the relative date range I'm wanting to count between. I just don't know how to convert this into…
-
Status Formula
Hi all, I am struggling to create a formula that works and wonder if you can help me…. Duration Equal to or Less than 0, Gray. Duration Greater than 0 but “Email Sent” & “Return Old Device” unchecked, Yellow. Duration Greater than 20 but “Email Sent & “Return Old Device” unchecked, Red. Duration Greater than 0 and “Email…
-
Would Like to Copy a value from one location to another weekly
Hello! I have 2 sheets SHEETA and SHEETB. SHEETA has a ton of data in it and I want to take a value from one cell inside or the sheet summary it and copy it weekly to another sheet. I know I can copy rows but that is not an option for me. Is there another method I could utilize to automate this?