Formulas
Discussion List
- I am a bit stumped and looking for a little help. I have a forecast sheet with a form where the user has to submit their monthly forecasts for the quarters across five subject areas. I have a column f…
- I am trying to look at a column on one sheet and if it contains a certain value or multiple of the values that I am searching for, return a sum of value(s) from one or more specific cells that are con…
- 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 …
- 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 S…
- 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 …
- 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 individ…
- 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…
- 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 specif…
- 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 re…
- =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), 1…
