Conditional Formatting Using AND

04/14/21
Accepted

Hi

I want to apply conditional formatting to grey a row out where someone is one of the family leave options e.g. Maternity Leave and the date is in the future (as if the date is in the past I don't want it to show as greyed out).

I have added the following conditional formatting but, as you will see from the screen shot the row has not turned grey despite the criteria being met. Any ideas?


Many thanks

Cheryl

Best Answer

  • Bassam KhalilBassam Khalil ✭✭✭✭✭
    edited 04/19/21 Accepted Answer

    Hi @Cheryl Collins

    Hope you are fine, i solved the problem of the Family Leave End Date column for you and i created the conditional formatting as you need, please check the sheet you shared.

    As @Paul Newcome and @Andrée Starå i found a problem in Family Leave End Date column.

    Best Regards

    Bassam.M Khalil


    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful". 

Answers

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Try moving that particular row up in the list. Conditional formatting will start at the top and work its way down, stopping on the first rule that is true.

    thinkspi.com

    [email protected]

  • Cheryl CollinsCheryl Collins ✭✭✭✭✭

    Hi @Paul Newcome

    Thanks, I've moved the row to row 1 but it hasn't made a difference.



  • Paul NewcomePaul Newcome ✭✭✭✭✭

    My apologies. I meant the rule itself within the conditional formatting tool. Not the row within the sheet.


    Try reordering the rules.

    thinkspi.com

    [email protected]

  • Cheryl CollinsCheryl Collins ✭✭✭✭✭

    Hi @Paul Newcome

    Unfortunately, this has not solved it.

    Any other ideas?

    This is one of my bug bares with Smartsheet that the simplest of things turns into a very time consuming exercise! 😔

    TIA

    Cheryl

  • Bassam KhalilBassam Khalil ✭✭✭✭✭

    Hi @Cheryl Collins 

    Hope you are fine, could you send an exported excel copy of your sheet (after removing or replacing any sensitive information) to my Email and i will solve it for you. and please write in the Email a sample for what you want the conditional formatting to do.

    My Email : [email protected]

    Best Regards

    Bassam.M Khalil


    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful". 

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

    Hi @Cheryl Collins

    I hope you're well and safe!

    Strange!

    It looks correct!

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

    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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    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 about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    That is strange for sure.


    At this point I would suggest taking @Andrée Starå up on his offer to take a look at it within Smartsheet. I have a couple of other ideas, but being able to have someone take a look directly should be a bit quicker than trying to go back and forth here in the forum.

    thinkspi.com

    [email protected]

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

    @Paul Newcome

    We found the issue. The date isn't coming in as a date from a cross-sheet formula.

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    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 about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    @Andrée Starå That was going to be my next suggestion, but I figured you would check that. Glad you were able to get it figured out.

    thinkspi.com

    [email protected]

  • Bassam KhalilBassam Khalil ✭✭✭✭✭
    edited 04/19/21 Accepted Answer

    Hi @Cheryl Collins

    Hope you are fine, i solved the problem of the Family Leave End Date column for you and i created the conditional formatting as you need, please check the sheet you shared.

    As @Paul Newcome and @Andrée Starå i found a problem in Family Leave End Date column.

    Best Regards

    Bassam.M Khalil


    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful". 

  • Cheryl CollinsCheryl Collins ✭✭✭✭✭

    Hi @Bassam.M Khalil

    Thank you so much for your help with this, it's working like a dream!! 😊

    @Andrée LaRivière @Paul Newcome Thank you both aswell for your input and assistance. Always really appreciated.


    Cheryl

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

    @Cheryl Collins

    You're more than welcome!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    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 about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Bassam KhalilBassam Khalil ✭✭✭✭✭

    @Cheryl Collins

    Am glad that my answer solve your problem, and i will be happy to help you any time.

    Best Regards

    Bassam.M Khalil


    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful". 

Sign In or Register to comment.