Welcome!

formula to turn red flag on at risk column on set no. of days before Completion Date

Hello.

Please help w a formula to turn the red flag of the 'at risk' column for various number of days before the date set in the Completion Date column.

Thank you.

Dan

at risk flag.JPG

Formulas

=IF([Completion Date]@row >= TODAY(- #), 1)

Give this a try. Just replace the # with however many days you want to trigger the flag.

Thanks very much for your prompt reply and suggestion.

I'll try it and let you know if I succeed, if it works.

Best,

Dan

Happy to help.

Problems with turning off automatic backups
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?
Average by section within a column
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…
How to return a blank when searching for max date and one of the dates is blank
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))