-
Count if Specific Text within a Date Range
I'm trying to create a formula to count a specific text within a column only when it's during a specific date range. I can't figure out where my error is. =COUNTIFS([Branch Selected]:[Branch Selected], "East Branch", [Date]:[Date], >= [2020-08-01], [Date]:[Date], <=[2020-08-31])
-
Establishing Automatic Due Dates
I have a project that has a launch date of July 2, which is represented in a column. I would like to have a due date be automatically calculated 63 days prior to this date, in another column. I have created a formula that appears to work, in principle, but rather than setting the date 66 days prior to the July 2 (April…
-
Formula help: log a date in sheet 1 when all tasks assigned to me in sheet 2 reach a certain status
I am wanting to create a formula for the below scenarios, but am not sure how I would go about it or if it is feasible - For each new job, we create a sheet to log POs and subcontracts needed, and a second sheet to track project deliverables. One deliverable is to have all the POs/Subs complete, a second deliverable to…
-
Why is my VLOOKUP returning erroneous data?
I am using a cross-sheet VLOOKUP formula on several rows in a master sheet. It is working correctly in one column, but for the other column the formula is returning erroneous data for only a few rows. For instance, in a couple of cases it is finding a search value that does not exist in the referenced sheet, then returning…
-
Join Function Not Working As Expected
When I join across cells it is taking the last option from the Core Column and the first option in the Calyx Column and combining the text. Any suggestions will be helpful. The formula I am using is =JOIN(Core1:Calyx1, " ")
-
A Single Formula to SUM a variable range of cells in a row
Hi, I am trying to write a formula that will SUM between one and twenty columns in a row, based on the number in another cell in the same row. If the number is 20, I want to sum all 20 cells in the row. If the number is 19, I want to sum the first 19 cells. The range is always contiguous, and the cells to be summed always…
-
How to capture a value from multi-select column
Which formula works better to find out if a value exists in a multi select dropdown column? I have responses collected from a survey and one of the column was multi-select dropdown list type column. I'm trying to separate out the selection values and adding them in a separate sheet (so using cross sheet reference). Have…
-
Formula to add 1
I am trying to figure out a formula that will add 1 to the Parent [DMR #] The below will Place a "1" at the end but I need to add count by one Like this DMR5575-1 DMR5575-2 DMR5575-3 =IF(Level1 = 0, [DMR #]1, PARENT([DMR #]1) + "-" + 1)
-
Need help with a VLOOKUP and MATCH formula
Hi there, I confess I get so lost when it comes to formulas. I've read through various community discussions and help pages, but for some reason I just cannot get the logic of creating a formula. In sheet 1 I have a column for "Freelancer." In sheet 2, I have a one column for the "Freelancer" and one column for "Payee,"…
-
Is there a way to pull only the children into the report?
I am trying to have a report that shows only the lowest indented children in it. I am working on a sheet that has 4 level of indents. Workstream (indent 0), Project (indent 1), Milestone (indent 2) and Activities (indent 3). The report needs to include activities only and not any of its parents. Please let me know if there…