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 have one sheet that is tracking PTO where a user has entered the days off. The form allows them to enter a start and end date for their PTO and enters a single record into the sheet. I have a second sheet that I am looking to pull that data into, but there is only one record per person (column in this sheet where the…
I am trying to get the passenger count per month per year, and I can't seem to get the formula correct. I need to add the number of passengers for each month per year. If anyone could assist me with this, I would greatly appreciate it. Thanks!
Date Report Partner CBO Name 01/12/25 Children's org 05/15/25 Foodbank 08/30/25 Children's org 09/11/25 Chamber 11/25/25 Digital Bus 08/21/24 Digital Bus South 01/15/26 Children's org 01/12/24 Foodbank Sister 02/15/24 For the children org 07/01/26 Digital Bus #2 08/05/26 Family Center 12/01/26 Family Center I am trying to…
