Conditional Formatting

I have never had this issue but currently I have conditional formatting set to make a cell 'red' if the due date is in the past. The date is calculated based on a formula from other cells but this is a date column. The conditional formatting will not work. I have several dates in the past and none are following the formatting set up. Is there an issue with formulas and conditional formatting? As I stated already, I have never had this happen especially on something so simple!

Tags:

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @Amanda King

    I hope you're well and safe!

    Have you checked the order of the rules?

    Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Amanda King
    Amanda King ✭✭✭

    Thanks! I am good except for this craziness! I removed all of my other rules and just went to the one that wasn't working first to try to correct it thinking I had something wrong. Below is a screenshot of my 'simple' rule. I just want the Baseline Data Due column to be red IF that date is in the past. Nothing else at this point. As you can see, there are several in that column that are indeed in the past.



  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    @Amanda King

    Happy to help!

    Glad to hear that you're good!

    Yes, that is a little crazy.

    What happens f you make a copy of the sheet?


    I'd be happy to take a quick look.

    Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!