-
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…
-
Merged: Report Filter - Error in recognising dates?
This discussion has been merged.
-
Looking for the most recent date - across several sheets
Hi all, This formula works perfectly when referring to 1 sheet - =MAX(COLLECT({Competencies Awarded Range 1}, {Competencies Awarded Range 2}, "Bob Jones")) The forumla is to find the latest date that a internal learning unit was submitted. However due to the number of internal units it has been decided to split the sheet…
-
Hide rows with duplicate values
Hello, I have a spreadsheet where the primary column has cell entries where there are duplicate names, which are intentional to show variations. How do I show the primary column where duplicate names are hidden? Thanks, Amy
-
Updated formula breaks Calendar Report
Good afternoon. I have a Calendar report that is looking at 11 sheets. All sheets have two check box columns that add data to two separate Calendars in the Calendar App. I was originally using this formula: =IF([RegOps Overlay Calendar]@row = 1, JOIN(ANCESTORS([Task Name]@row), " - ") + " - " + [Task Name]@row, "") and…
-
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…
-
Importing data
I have a question. I have multiple sheets that feed into a report. The sheets have projects in them with actuals and remainder of year forecast. the data feeds into the report. At the end of the month that months actuals are loaded. Currently, the actuals are loaded on the report and pushed down to the individual sheets.…
-
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.…