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

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.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!