-
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…
-
Multi-select dropdown column to pull single value in another column
Hi Everyone! I need some assistance with a formula to extract single value from a multi-select drop-down to individual columns. I got most of the process to work but for whatever reason the formula for control 4 column ends up displaying a incorrect number "12." instead of "12.1" and control 5 column displays the whole…
-
Contact Field Listing Multiple Contacts to Feed Individual Rows in a Report
Is it possible to parse out a contact field with multiple contacts into a report or new sheet listing each contact on its own row? If that is not possible, can you do the reverse? I hope this makes sense.
