-
#Invalid Data Type
Hello, I have a formula in my sheet summary that was working until recently. For some reason the formula is no longer able to count the months or years in the sheet. I also receive the error when I remove the [Current Month]# from the formula and try putting "11". Does anyone have any recommendations or see anything wrong…
-
How to write a formula based on 3,6,9 months from current date, using G/R/Y/G symbols?
Hi, I am trying to write a formula that uses the gray, green, yellow, red symbols to show how close we are getting to something expiring. If the Patent has not yet been filed (date is blank) this would be the gray symbol. If it has been filed and is under 6 months old, green; if it is between 6 months - 9 months from the…
-
Seeking some assistance/guidance on Rollup / Headers (formula)
I've reviewed some of the Rollup documents, and it appears some of what I'm thinking is do-able, but perhaps not fully, depending on how the formatting works... Appreciate any insights! I have a project where I have several drop down status’s for tasks such as (STATUSA, STATUSB, STATUSC). Since I have so many subtasks,…
-
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.
