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

Find more posts tagged with

Formulas

Comments

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!

Sign in to join the conversation!

Quick Links

Trending discussions

Status Log Push to Dashboard
I want to push the latest status log sheet entry to the dashboard. I have added working columns for the last date, recent value (0 or 1) and recent status (text field). The recent columns are blank except for the most recent data rows (that part of the sheet is working). I have a project metric sheet template across topics…
Calculate Project Time TOTAL for PM across aligned projects
Hi - I am trying to figure out how to create a SUM of the Total Project Time aligned to each PM for all of their projects. On my master sheet I have the Resource Type, Resource Name, and a Helper Column for Time. The Helper Time is an estimated allotted time based on the timeframe of the project. Example: <3 months = 25…
Sheet Summary Formula
I am looking to count how many letters we have issued within each month, this is by going by the modified date, these are the formulas i have tried as i want to start this from August: =COUNTIFS(Modified:Modified, MONTH(@cell ) = 8, Modified:Modified, YEAR(@cell ) = 2025) However, it comes up with an error. Any ideas…