IF formula for color indicators

Options

Hello,

 I’m hoping for some help with color indicators for a project schedule. If someone could help with the formula I would greatly appreciate it.

Here is what we are looking for using the @ row references if possible.

·      If 0 day duration and % Complete = 100, return Blue

·      If 0 day duration and the scheduled finish is at least seven days away, return Clear

·      If 0 day duration and % Complete is < 80, return Red

·      If not 0 day duration and % Complete is between 80 and 99, return Yellow

·      If not 0 day duration and % Complete = 100, return Blue

·      If it’s not 0 day duration and not scheduled to start yet, return Clear

·      If it’s not 0 day duration and past the scheduled finish date, return Red

·      If not 0 day duration and % complete >= the prorated expected completion, return Green, Otherwise, return Yellow.

·      If not 0 day duration and Start date is in the past AND finish date is in the next 7 days AND % complete less than 50%, return Red

Column Names:

% complete

Start

Finish

Thank you for any help you can provide

Best Answer

Answers

  • Nichole Pyle
    Options

    This is fantastic! Thank you so much, I realized the one component of the formula that you were struggling with is not feasible given the way we structured our template so no worries on incorporating it. Your help with this is very much appreciated.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!