Formula Needed: Past due indicator Y/N based on % to Completion and Target End Date

MJeffers

Hello All,

I need assistance writing a formula that does the following:

If column % to completion = 100%, then column Past Due (Y/N) will = N

If field % to completion is < 100% and column Target End Date is < Today, the Past Due (Y/N) will = Y otherwise N

Any assistance is appreciated.

MJ

Carson Penticuff

Try this

=IF(AND([% to Completion]@row < 1, [Target End Date]@row < TODAY()), "Y", "N")