Hi all I have a sheet which has a deadline on it. This deadline may be extended for a variety of reasons (unable to get parts, Waiting for a return email etc) Is there a way to have a check box that, when ticked, It'll add a day to the deadline automatically as it passes. At first, I thought this would be possible via…
I want to alter this sheet, found in the IT ticket Template, to just show the metrics for a specific customer. the original formula looks like this: =COUNTIF({Created Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - 1) and my attempt to specify to a single customer looks like this =COUNTIFS({Created Date Range},…
