I have a spreadsheet located on Google Drive.
I need a formula in column "GT" that will count the number of days in each row that have either an "X" or "RDO". When that number hits 14 or more consecutively, the name in the "Name" column will turn red. It must also reset itself when the streak is broken and start the count over. The formula that I have now doesn't seem to be reliable. Any help would be very much appreciated.
I need a formula in column "GT" that will count the number of days in each row that have either an "X" or "RDO". When that number hits 14 or more consecutively, the name in the "Name" column will turn red. It must also reset itself when the streak is broken and start the count over. The formula that I have now doesn't seem to be reliable. Any help would be very much appreciated.
