# Formula driven by date

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

Tags:

• 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"))))

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

• No, it did not work. I still need help

• 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")))

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!