-
I am looking to use an Index match to concatenate a persons roles
I have a sheet to track workers roles however, some people are listed multiple times as they have multiple roles because depending on the project their role is different. I was wondering if there was a way to use an Index(match( to either concat all of their roles in 1 formula without the use of a helper column. My current…
-
Is there a revised formula that will allow me to show more accurate training dates?
I have a formula in a training matrix that compares dates of when a document revises and when the training was carried out for employees. =IF([Revision Date]@row > [employee]93, true, false) However, this returns a red font date if the revision date is greater than the training date, even if the employee was trained prior…
-
Hyphens between combined cell data when not blank
Hi, I have the below formula to combine a number of cells together to make a naming convention. I want hyphens between each piece of information but only if the cell is not blank. We only have a Program Code 2 about half the time, I don't want an extra hyphen in there when it's a blank cell. The combined data at the moment…
-
Remove BLANK in PIVOT TABLE
How to remove BLANK values in Pivot sheet. The source sheet is having a default rows, but I am maintaining limited rows and rest of the blank rows are reflecting in Pivot sheet. How do I remove ?
-
Cell-link: Duration and Start Date - End date isn't same
Hello Community people, I have same duration and Start (date) in 2 sheets, which linking is set. But End date gets different. Dependency settings (Working Days and other items there) are exactly same. Start . End . Duration Original sheet 5/7/18 5/6/19 260d Linked sheet 5/7/18 5/3/19 260d This task does not have…
-
Formula Help
Hello, I recently used this =SUMIFS formula and now that I have changed some VLOOKUPS the formula gives me a #NO MATCH error. SUMIFS([Request Total]:[Request Total], [Employee ID]:[Employee ID], [Employee ID]@row, Date:Date, <=Date@row, Date:Date, >=DATE(2022, 7, 1), [Department Approval]:[Department Approval], "Approved")…
-
Cross referencing same range across multiple sheets
I am using one sheet, call it Program Data, as my source data for piping into my many Project Sheets. The Project Sheets have a Project ID in one cell that determines which line of the Program Data sheet to call out (e.g. Start Date, Team Lead 1, Team Lead 2, Team Lead 3, ...). I can't find a way to link each cell without…
-
CountIF / IsDate combination
Hello I am trying to link formulas to count from a list or column all the cells that contain date and discard that which are text. But I can not get the combination of the formulas to work well. Thank you in advance.
-
Copy updated cell values of one sheet to another
Hi, I have two sheets with exact same columns. When any cell(s) value of row in sheet 1 is updated, then I want to update same row with unique identifier ID if existing in sheet 2 to be updated with new cell values as well. Please help how it can be accomplished. Example: Let say Price Per unit of Row 3 is changed in first…
-
Cell-linking - counting values from a sheet into the cell of another sheet
Hi everyone, I'm trying to create an event summary sheet that captures data from individual event sheets to provide a live overview on where we're at with completion, health, risks, status, etc. And so I have a cell "Health" in my specific event sheet that has a number of dots (red, green, gray) depending on with the task…
