-
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.…
-
Need Formula - Total # of "Working Days" Left
Hello and thanks in advance for your help! I would like to automatically calculate the total # of "working days" left (as of today) by referencing the Due Date. I did find a formula for total number of all days left "=[Due Date]23 - TODAY()" but I haven't been able to find one that just calculates working days. Here…
-
Index Match formula populating when form added, without cross sheet being populated
I have a sheet for division entry. When it is approved by the director a workflow copies the entire row to a master sheet, where the commissioner approves. All approvals are a drop down symbol. When the commissioner approves, there is an index/match formula on the division sheet, indicating if commissioner approves or…
