-
extract city & state from a city, state, zip cell
I want to extract the city & state from a cell that has the city, state and zip code. The zip code may not always be 5 digits (either 90210 or 90210-1234) and the City and State may not always have a comma separating them. A formula that can extract any text left of a numeric value is what would solve this, but I cannot…
-
Automatic Predecessor Adjustment
Hey All! I have a question about how to have predecessors or just tasks in a schedule to automatically update when they are moved in the schedule. I am trying to create a production schedule for our Sheet Metal shop and it is created with the fabrication packages released from the Eng Dept. Sometimes the schedule needs to…
-
Can I use the Substitute function to remove a line-break?
Hello! I'm having success nesting the substitute function to remove multiple things from a field of text in a cell and replace them with a blank space. I would like to remove line-breaks/enter/return and replace them with a semicolon. I'd like to turn something like this: Meredith Rhodes, PhD Meredith Rhodes, PhD Into…
-
Extracting just the numbers from auto generated Created field
I know how to extract just the time or just the date from auto generated Created and Modified fields. I also know how to remove the : and PM/AM from the time and / from the date. All this done individually. My question - is there a simple formula to extract JUST the numbers from the auto generated field? Or can someone…
-
Exclude Current Row
I am working on a formula where my final piece needs to exclude the row my formula is in. My Current formula is: =MAX(0, (PARENT([FCB LAB]@row) - SUM(CHILDREN([Baseline Labor]@row))) / 45) Can someone show me how to exclude the row my formula is in when summing the children of the Baseline Labor? For further clarification:…
-
Incorrect Argument Set for MATCH, IF, AND formula
Hi there, I feel like I'm close to a solution. I'm working in a symbol column that I would like to automate to turn either Gray or Green. I would like to match a row across different sheets, if specific columns are blank on the other sheet for the match row, I'd like to return a gray symbol, if any one of them is not…
-
See who changed cross sheet references?
Hello, Is there any way to see in the activity log who changed a cross sheet reference? I have a sheet set up with dozens of cross sheet references used in Index/Match etc., and recently one of the reference ranges was changed to look at a column in a completely different sheet. Any insight?
-
Date Output is incorrect on date formula
=IFERROR(DATE(YEAR([Effective Date]@row) + ROUNDDOWN((MONTH([Effective Date]@row) + ([Contract Term (Months)]@row)) / 12, 0) + IF(IF(MOD(MONTH([Effective Date]@row) + ([Contract Term (Months)]@row), 12) = 0, 12, MOD(MONTH([Effective Date]@row - 1) + ([Contract Term (Months)]@row), 12)) = 12, -1), IF(MOD(MONTH([Effective…
-
How to find if someone is assigned to two tasks on the same day?
Good morning, I have a sheet with due date in one column and team member assigned in another column. I want to ensure no one is assigned two tasks on the same day. I have exhausted my googling abilities and have come up empty. Any ideas here?
-
COUNTIF & WEEK
Hi All, A client wants to be able to see how many calls were logged in thier current working week . However the working week begins on a Friday 00:00am and ends Thursday 11:59pm. I'm after a formula to count all entries with the word "Aberdeen" in the Column called "Club" in the mentioned working week . This counter would…
