-
How do I create a formula to show how many weeks/days out a task needs to be completed?
For example, if I have an event, or a project live date, and I want a task list that says Task 1 is due 8 weeks prior Task 2 is due 3 weeks prior etc...I am new to this and cannot figure out the formula!
-
Countif not containing specific text
I am trying to create a formula to count "Red" based on one column but not include certain ones which contain the text "Spring" in another column but I can't get it to work. Originally I tried this formula: =COUNTIFS([Aging]:[Aging], "Red", Project:Project, <> "Spring") However, I realized that won't work because the…
-
Parsing Text into Child Rows
Good morning. I am running the Jira Integration, and I would like to create a view or report that lists linked issues (in the 3rd column from the screenshot) as child rows. The text will always be in the format ("includes OR-X") but I have several problems parsing the text. The key number (ex: 2437) could have up to 6…
-
How do I count the number of checkboxes within a column range?
I am trying to count the number of checkboxes in a column range and am getting errors. I would like to get a result that provides a summary of a specific range within the Priority 1 column. I have looked at some of the other posts related to this similar topic without success. Any help or guidance would be greatly…
-
Using the YEAR formula to convert a DD/MM/YYYY column format to show YYYY in another column
Hi All, I am trying to create a formula to take the date column (DD/MM/YYYY) called "travel in date" and convert it over to YYYY in another column called "Year". However, the following formula =YEAR([Travel In Date]16), it is converting over but showing the value incorrectly as 2022 when the date in the referenced cell is…
-
CONTAINS: What's it all about and how does it work?
I personally am still getting used to the new CONTAINS function, and I have noticed a few others on here looking for clarity. I figured I would start this thread in an effort to hopefully combine knowledge and do some collective brainstorming on how it works and some good examples of use cases. I'll be revisiting this…
-
Formula to count rows in a report
On a sheet, is there a way to write a formula to count how many rows are on a report. We have many reports and would like to know how may rows are in each report on a single sheet.
-
VLookup returning values from a different row
I'm stumped on this one. I'm running the following formula: =VLOOKUP("In Progress", [Phase - Task]:[Phase Status], 1) 1st column in the table is Phase - Task. VLookup finds the value "In Progress" on row 6 in the Phase status column, but then returns the value from Phase - Task from row 4. I've never seen VLookup pull data…
-
Incrementing a Number by One for Each Time a Status is Selected
I have a sheet where we have a variety of values in a Status column. I am looking to have a separate column that would count how many times a row has gone through a particular status (" Revise") so we can see how many rounds of revisions a particular project goes through. We were going to call it "# of Revisions". The…
-
Returning a Date Value from Another Sheet if Certain Criterias are Met
I have been working on the formula to return a date value from another worksheet if certain criterias are met. Here is the formula i input but with a formula error of #UNPARSEABLE =INDEX(COLLECT({Send Out Date}, {Range}, =CONTAINS("Bank Confirmation", {Range}), {Client ID1}, =CONTAINS([Client ID]@row, {Client ID1}))),1)…
