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:
I currently have 14 sheets with the following columns: Batch # and Reviewer I use an Index Distinct formula to acquire the unique batch numbers from all 14 sheets and put them into 14 columns on the 'metrics' sheet. I then use another index distinct to get a list of all the unique batch numbers into one 'Unique Batch…
Hello, I am looking for formula help where I want to return the earliest date in a range for different workstreams groups on a project. The source sheet is formatted as a date field, and the formula used below is returning a 0 no matter what I do. Any suggestions? =MIN(COLLECT({Project Plan - start date}, {Project Plan…
When I use a formula to return a symbol for example =IF([INC/DEC]@row = "INCREASE", "RED", "GREEN") It just returns the word RED I have the column set to symbol but still can't get it to work…
