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.
MJ
Best Answer

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

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

Thank you Carson for the prompt reply. This works perfectly
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!