Sign in to join the conversation:
is there an ability to set a conditional format based on two columns in the same row:
completed (column) date is later than the due (column) date – the cell turns red
completed date entered is before (or after) today's date
Yes, there is! Thought its kind of hidden. After you set up a conditional formatting you have to click on the arrow to the left of the condition and add another condition. See Screenshot.
I am trying to turn off weekly backups, but it's not checked and it shows no history, yet I get backups every week. Is this a bug or there is another place I have to disable it? If it's the right place, why is there no history now?
I am working on a sheet where we are tracking the percent complete within a column. The top percent complete formula is =AVG([Percent Complete]2, [Percent Complete]17). The formula in [Percent Complete]2 is =IF(Completed@row = "Completed", "100%", COUNTIF(Completed3:Completed16, "Completed") / 14) The purpose of the…
I'm searching another sheet date column for the max date where two number columns (CID) are equal. It works fine, but if the list of dates contains a blank, I want the formula to return a blank instead of the max date it finds. =MAX(COLLECT({DAFD}, {CID}, @cell = [CID]@row))
