Formula driven by date

Tony Barthelemy

Hi All:

I only want this formula to activate only if it is greater than or equally to today's date, but having trouble adding TODAY part of the formula:

=IF([% Complete (Actual)]3 > [% Complete (Planned)]3, "Up", IF([% Complete (Planned)]3 > [% Complete (Actual)]3, "Down", IF([% Complete (Planned)]3 = [% Complete (Actual)]3, "Sideways")))

Thanks

 

Tony Barthelemy

My 10th attempt to get the formula to work:

 

=IF([% Complete (Actual)]4 > [% Complete (Planned)]4, "Up", IF([% Complete (Planned)]4 > [% Complete (Actual)]4, "Down", IF(AND(TODAY() > [Start Date (Planned)]4, [% Complete (Planned)]4 = [% Complete (Actual)]4, "Sideways"))))

ricki

Did the tenth attempt work or do you still want help with this one?

Tony Barthelemy

No, it did not work. I still need help

ricki

The issue is the location of your closing parenthesis ... the end should be

 

Your two conditions in the and need a closing ) before you put it what to do if the if part is true

 

 IF(AND(TODAY() > [Start Date (Planned)]1, [% Complete (Planned)]1 = [% Complete (Actual)]1), "Sideways")))

Tony Barthelemy

That worked, Thanks!