-
Project Revenue Review Formula
-
Best practice of recording occurrences
Hello - apologies if this has been covered elsewhere, I've tried to search for the answer but can't find anything which may work for my purposes. Ultimately, it may not be achievable, but I thought I'd ask: I am creating a group of sheets for a team I work with, and they're dealing with recruitment of individuals (inwards…
-
How to make a different rul???
Hi I want to make a rule, so my health symbol automatically turns green if the status changes to completed. Can anyone help?
-
Date Formula
Hi. I have finish dates for tasks and need to start them 120 days prior to that. How would I write that formula. Thank you!
-
Populating text cells that show minimum value
I am in the process of creating a sheet to populate low bidders. I have two columns; vendors and total cost. I've included a cell formula in the total cost column to automatically populate the low bid value : =min(cell1, cell2, cell3, cell4, cell5). My question is, how can I create a cell in the 'vendors' column to…
-
¿Automatically sum up child values into Parent Cell?
I'm looking for a solution to automatically sum up child values for selected numeric columns. There is a workaround that is to use sum(children()) formula, but I dont want to write the formula every time I add Parent rows. Any ideas? Thank you.
-
Auto showing completion based on child checkboxes
Hello. I've setup a task list with check boxes. After indenting portions of it to show child tasks, is there a way to have the parent row automatically highlight, or show a value, when all the child tasks are complete? I would then link the parent row back to a master sheet to show a completion on a single line in the…
-
Current work filter for tasks not Complete and Due in the next 2 days or the past
I am trying to build a filter that will be utilized to Identify Current and Past due work. I can get the filter to find all not Completed or Canceled work in the Past or the Next # of days. I cannot get it to find all taskx from 2 days in the future and older. Is there a way to add a formula when using is less than or…
-
Mid and Value formula
-
Status of Child rows
Hi I am trying to create a Project Schedule with Budget and Variance and include an overall status using the status of the child rows. I have 1 line that is the overall project and then 4 phase lines, with around 20 tasks underneath each phase line. I want the phase lines to give an overall status of the child task rows…