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.

SUMIFS keeps returning 0
I'm trying to display a sum of the column Total Funds Available when Status = Apps Open, and Value Score = 5. Here is the formula I have: =SUMIFS([Total Funds Available]:[Total Funds Available], Status:Status, ="Apps Open", [Value Score]:[Value Score], ="5") There are rows that meet these conditions and should display a…
Create Sequential, Unique ID for certain rows as column formula
I need a column formula that can add sequential, unique IDs to data like this coming in from a form: Task Type Task ID Manual M001 Automated Manual M002 Manual M003 Manual M004 Automated Manual M005 Task IDs that aren’t the manual type need sequential numbering within their type (i.e. A001, A002, etc). Here’s the kicker:…
Finding Unique Dates
I looking to find unique values, in order, and separate them into columns. The "Client Update Date" column will contain dates, not in order and some dates may be duplicated. In the "1st Date Feedback I'm getting the correct date of 12/12/25 with the formula: =MIN([Client Update Date]:[Client Update Date]) In the "2nd Date…