I am trying to create a formula similar to what we use in our PWA environment but this is just for SP. I tried using my formula from PWA but it would not work. What I am trying to do is something like this
=IF(AND[Due Date]<NOW(), [% Complete]<100%,"Late")
I will be adding additional IF statements to this formula as well to represent On Schedule, Complete and at Risk
Any help is greatly appreciated