Formula driven by date

Tony Barthelemy
Tony Barthelemy ✭✭✭✭
edited 12/09/19 in Formulas and Functions

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





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!