-
countif/contain formula
Hello I need a formula for the Sheet summary that will give me the total based on section id/status color. instead of creating 3 fields for each color status
-
INDEX COLLECT not working!
I have an estimate sheet, where I am referencing pricing from another sheet with multiple criteria - trying to use an INDEX with COLLECT formula. Please see screen shots attached. The formula I am using is: =INDEX(COLLECT({Rental Cost}, {Equipment Description}, [Equipment Description]@row, {Units}, Units@row, 1)) This…
-
Combining IF and IF AND Formulas
I have three formulas below that work as individual formulas. I am trying to combine them in my Status column into one formula so my cell automatically updates based on the percent shown in the % complete cell. I thought it should be =IF([% Complete]@row = 0, "Not Started"), IF(AND([% Complete]@row > 0.01, [% Complete]@row…
-
#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…
