-
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!
-
Printing Gantt Charts
Does anyone know how to stop the previous months that have no data in them from being printed with the Gantt chart as its pushing the chart off an A3 size paper.
-
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…
-
Lookup Function-bottom to top
Is there anyway to use lookup function to find the match from bottom (most recent) of the table rather than finding the match from top?
-
Reoccuring sheet
Hi, I'm using a reoccurring sheet and would like to use, besides a days between column, also a months between column so that the due date can be calculated with days but also with months. How do I create such a formula? Hans
-
SUMIFS() FUNCTION with more than 5 CRITERION
Dear Everyone, How to use sumifs() function with more than 5 criterion range. It returns zero (0) even it is already satisfied with the data given for each column. =SUMIFS($Qty:$Qty, $Road:$Road, [Look Roads]1, $[Cabinet No.]:$[Cabinet No.], [LkCabinet No.]1, $[H. H. No.]:$[H. H. No.], [LkH.H.No.]1, $[Line Type]:$[Line…
-
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…
-
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…
-
Link to a cell in the comments
Hi, Is it possible to paste a cell link in a comment of another sheet? I have a sheet in which certain rows refer back to other rows in other sheets. I want to be able to paste that cell link in the comments for quick access. Y
-
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?
