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

dandoghi

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

Paul Newcome

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

 

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

dandoghi

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

Paul Newcome

Happy to help.