Formula for a Flag Column Based an If/Or statement

pkburns

I'm trying to write a formula using an IF/OR statement to set a flag (for the Revised Timeline column) when NA has been selected from a drop-down menu in the any one of five columns (e.g., Reason for Revised Analysis End Date). The flag should turn red when anything other than NA is selected. If NA is selected, then no red flag. See the attached image.

Or, if it's easier, I could set the flag to turn red when the dates are changed in any of the five End Date columns.

 

reagan.cink

For row 1, type this formula in the "Revised Timeline" column (which should already have the symbol -> flag property:

 

=IF(OR([Printable Materials Identified]1 = "NA", [Tentative Timeline Created]1 = "NA", [Project Proposal Form Submitted]1 = "NA", [Project Proposal Form Approved]1 = "NA", [Reason for Revised Analysis End Date]1 = "NA"), 1,0)

 

Then use the drag-fill method to extend the formula down for all rows in the sheet.

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

Andrée Starå

Hi Dan,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting