-
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…
-
Need formula for % Complete of 3 specific rows in sheet
Hi - My project has 3 phases in it and I would like to be able to show not only the % Complete of each phase but for the project overall. I have each phase working by enabling the dependencies and it is already calculating for those but I cannot get a formula to work to calculate the over all % Complete for Row 1. Does…
-
Count number of dates that meet several criteria
What would be the formula that counts the number of dates that fall between a start and finish date if another column is not blank? Current formula I have is: =COUNTIFS({Dates}, >=[Start Date]@row, {Dates}, <=[End Date]@row) This is returning the total number of dates correctly. But would like it to return the number of…
-
Creating a metrics sheet based off a project intake form
Hello, I'm looking to set up a separate tracking sheet that captures ongoing counts based on our project intake form. I'm hoping to capture: # of requests created by Department (uses a dropdown on the main intake sheet) # of requests per Program (uses a dropdown on the main intake sheet) # of requests by Type (uses a…
