-
First Entry Flag equation as column formula?
Good morning! I'm trying to create a flag in my form receiver sheet to identify first entries vs. duplicates. This is to help me pull some metrics (counts) in other sheets. I have an equation that works row by row, but not in the very first row and also can't be converted to a column formula. What am I doing wrong? I'd…
-
I am trying to create a formula with varying conditions
I am trying to create a formula for the likelihood of a project. I have 2 helper columns and a final column. I am only worried about 1 of the helper columns as I cannot get it to work. The Conditions I am missing is for when a project is planned to start in the middle of a year, I want the % to carry over until 0, and…
-
Reference EACH child from the Parent on Another sheet
I want to display (from another sheet) the child rows. How can I use a formula, on each of my child lines that displays child1, child2, child3, child4, and child5 in my Release Name & Release column. I only require the ability to do this in these 2 columns. The black text is raw data (and the blue text are formulas).
-
Can I get help with a SUMIF formula for a Sheet Summary?
Is it possible to SUMIF a $ value column, based on a "this month" check box in Sheet Summary? I', using [Value]:[Value] and [This month?]:[This month?] for my columns. Thanks! Jen
-
Combining countifs and countif into one formula
Hi all, I have a sheet which includes two separate formulas, one, a "countifs" and one a "countif". Both work seamlessly in their respective columns. However, in reviewing my related dashboard, I noticed that my "countif" column was including a row of data it shouldn't and realized that I needed to amend my "countif"…
-
Assign duration on dropdown list items and update dates accordingly
Hello All, I am trying to see if it is feasible to add a specific duration (in days) to a respective item in a dropdown list. For example, I have the following dropdown list: 1 - Review feasibility 2 - Design Review 3 - MFG start 4 - Inspection And on each item, I would like to capture the duration as follows: 1 - Review…
-
Numbering Duplicates Based on a Date
Please see above a sheet for quote submissions, I want the revision number to automatically number the duplicates of service and contractor based on submission date with the oldest being revision number 1. Currently the Revision Number formula is: =IF(ISBLANK([Service + Contractor]@row), "", MATCH([Row ID]@row,…
-
Formula Question - Nested IF
Objective: "Status" column with symbols should update accordingly as per the information in the "% Complete" column which is in percent format Conditions: If "% Complete" is 100% then "Status" column should show green symbol, If above 70% & less than 100% it should show yellow symbol else red symbol. Need help with below…
-
Index Collect not providing exact match
Hello, I have a cell that is using index collect, but the value is not the expected one. I'm trying to find in a list of values the value that contains the sprint number. However when I'm looking for Sprint 1, I get Sprint 16 or Sprint 17. I guess when I have Sprint 20, something similar will happen. Can someone help me on…
-
Add JOIN Function to Index/Match
I am back, again! LOL Okay, My formula had worked initially, but that was when I only had one record. But since then I added added additional records, each with their own unique Release #s, and now everything comes out the same. I know what I need to do to fix it, I am just not sure how. Now the 2 screenshots show my data.…
