Need help on a simple IF/AND formula but already spending too much time on it

Looking to show 'Delay' for tasks that have %complete <100% and Finish date < than Today ().

Tried multiple variations but some records come right and some just ignore the %complete record. Why? Formula is: =IF(AND([% Complete]@row < "100%", [EMD Finish]@row < TODAY()), "Delay"). This formula is showing "Delay" on tasks that are 100%. This tasks are complete so should not show "delay".

Help! My brain is over this! LOL


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!