Sign in to join the conversation:
At my company we have certain dates when we do not make changes to our website (holidays usually). I'd like to be able to highlight or somehow flag a task if it falls within one of the freeze date ranges. Is there a way to do this?
How many different freeze ranges are there? If there aren't many, then you could build a nested if statement that would flag the row if the date is greater than or less than the date range. If there are a ton, I would consider keeping those ranges documented in a separate spreadsheet and do a countif statement that uses cross-sheet references to flag if there is the date on your current row meets the requirements of the holiday ranges on the other sheet. If it does, and the count is greater than 0 you could have it flag the row.
=IF(COUNTIFS({Cross Ref - Start Date Range 1}, <=[Due Date]1, {Cross Ref -End Date Range 2}, >=[Due Date]1), 1, 0)
To create a cross-sheet reference you have to click on the link in the formula helper to reference another sheet.
See my screenshot to see the formula in action.
For more on Cross sheet references:
In my job as a scheduler a common question is "which of the predecessors for this activity is driving the date?" Currently I have to rely on my own knowledge of my schedules or, worst case, I have to look at every predecessor until I find the one I am looking for. Microsoft Project is nice because it has the "inspect"…
Hi! I am trying to create DVs from this sheet that will do the following: In this screenshot example - Elizabeth is the roadmap owner, but Deb is the Calendar invite owner. So in Elizabeth's DV, I still need her to be able to see this row, but not be able to edit the Calendar Update Complete column. In Deb's DV, I need her…
Hi all, Is it possible to display some sort of graphic like this within a dashboard? I'd be taking data from a form and gathering total numbers of of "yes" and "non" questions to get the numerator and denominator for each row or column in the picture. I think I could do the metric sheet part of this task no problem, but…
