-
Index/Match, Collect, or Vlookup
I am trying to pull dates over from another sheet and matching on a unique value that is present in both sheets. However, the source sheet has the same unique value repeated multiple times and I want to return the date that IS populated. 1) {Schedule - DRL CMP WEQ Range 3} : this is the source range that contains the data…
-
SUMIFS not recognizing criterion when it is a formula
Hi, I have written a few simple SUMIFS that use the current month or current year as the criterion. However when I combine the RIGHT function in the cell with the criterion, the formula returns $0 (it should return $200). If I manually type 21 and set this as the criterion, the SUMIFS works. If I use the same formula and…
-
COUNTIFS of a text string based on a condition
I have two text columns. One column contains titles of documents. The second column contains specifies the document's "category." One of the categories in the "Category" column is "Presentations." However, in that category are two different types of presentation: "BDM" and "TDM". Whether a document is a BDM or TDM is…
-
Automate RYG Balls Based on Two Different Dates
I am trying to create a formula that looks at two different start dates to set the project status. It looks at the first start date to see how far out (TODAY) is from that date and looks to see if there is a date in the second start date. This is what I have so far: =IF(AND([Start Date]17 >= TODAY(+28), ISBLANK([Start…
-
VLOOKUP: How to make into a Column Formula?
Good afternoon! I have the following formulas that I need to convert to a Column formula, any ideas? =VLOOKUP([Assigned Tech]2, {Team List Range 1}, 2, false) =VLOOKUP([Model Number]1, {Master Parts List Range 1}, 2, false) Thanks! Ashley Pierce
-
Presenting N/A or Entering Date in Reports
Hello, We are attempting to come up with a formula that will present N/A in a Date column if the parent column lists N/A, otherwise we want the date functionality to work by presenting a calendar the user can select the date from on their individual report. What we are running into when the report is created is that the…
-
I'm Stumped - Need a Percent Average when applicable
I have tried a number of ways to get this to work, and my hunch is I'm needing a percent average from other percent averages (where some may be an iferror result that needs to be unaccounted for). Attached is an image of the work. I need the average percentage of projects on design schedule for those with projects in…
-
Count if date range
I am trying to create a formula that will tell me how many tasks that contain Map that are Flagged for CSO responsible that are due in 7 days, 14 days and 30 days from the Current Date or Revised Date (whichever is the great of the two)
-
Calculating SUM pending on dropdown selection
Hey all, I'm trying to calculate a sum pending two different drop down selections but having challenges with making it work. Any help would be greatly appreciated! =IF(OR(Coverage@row = "Travel", Coverage@row = "Local", Coverage@row = "2 Locations"), (SUM([# of Shifts]@row * 12))), (OR(Coverage@row = "Planning Only"),…
-
Count sheets in a folder and/or workspace
Hello All, Has anyone found a way to count items in a folder or workspace? Thanks Kevin