-
Formulas being converted to values
Hi - I have two sheets where I have created formulas that return a percentage for child tasks based on hours estimated and date ranges that ultimately feed into the resource management view. The formula works as expected (initially), but when I close the workplan and reopen, it will (at some point), convert the formula to…
-
How to calculate days a ticket is open/closed
I am trying to calculate how many days a ticket remains open but I also need that formula to stop counting if the "Ticket Closed Date" column is filled in. I have tried a couple but they keep coming back as errors. There are multiple selections for the Status of Ticket column... Work Has Not Started, Work Has Begun,…
-
If Children Contain then display cell on that row in Parent Cell
Have children() that vary in range, children rows can vary from 1 to ~30. For each child that contains "Action" in column [Issue Category] display the cell Notes contents into parent row Notes cell. Currently using static formula. Issue is every time a row is inserted, I have to manually add to the formula. Current formula…
-
How to estimate hours per Task using % allocation, Assigned to and Duration Columns?
Hi Everyone, I hope you all are doing alright. We need to estimate how many hours will problaby be spent on each task. We already use %allocation, Assigned to and Duration columns in our cronograms. We can't use the suggested formula "%allocation * Duration * 8" because: 1) Multiple employees can be assigned on the same…
-
Dynamic numbering of feature list
I have a feature list that has a number associated with each of them (by row). I'd like to be able to reorder the list as I get input on their priority and have the number associated with it dynamically update. For example, if #5 moves ahead of #3, I'd like #5 to be #3 and the others below to reorder too.
-
If Status is one of two options, then checkbox is selected formula
I am trying to build a formula where if a status is either "Pending-Crim" or "Clear w/ Exceptions" then the checkbox will check, however I can't seem to get the formula to check the box once the status has been updated. Here is the formula I am using: =IF(COUNTIFS(Status:Status, "Clear w/ Exception", Status:Status,…
-
if and blank
Hi, I have a date that a survey was completed and a date that someone has contacted a customer and I'm looking to create a formula that highlights if the response date was over 3 days ago AND there has not been a successful call (the contact date column will be blank) then mark this as red, if the response data was over 3…
-
Nested IF statements
Can anyone assist me in where I am going wrong? =IF([GEAR.]@row = true, [C/N SQD]@row, IF(LTG@row = true, [C/N LIGHTING]@row), IF(AND([GEAR.]@row = true, LTG@row = true) = true, [PROJECT TOTAL]@row)) If checkbox1 = true, set value to cell 1, if checkbox2 = true, set value to cell2, if BOTH checkboxes = true, set value to…
-
SUMIFS with Multiple Criteria
I have worked up SUMIFS that sums the Final COS for each of main Account Managers individually and for multiple codes in a contracted column that equate to a loss (this worked out fine): =SUMIFS([Final COS]:[Final COS], [Account Manager]:[Account Manager], "Doe", Contracted:Contracted, "not won") + SUMIFS([Final…
-
Formula Help
Not the greatest at creating formulas so I am looking for some assistance on this one. =IF(CONTAINS("0", [Product Categories selected]@row:[Keyword field filled]@row), "Complete", "Incomplete") Here is what I am looking to do: If the four columns are all "O" then mark the status of Incomplete but if all four columns are…