Conditional Formatting Using AND

Cheryl Collins

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

Bassam Khalil

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.

Paul 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.

Cheryl Collins

Hi @Paul Newcome

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

Paul Newcome

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

Try reordering the rules.

Cheryl 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 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 : bassam.k@mobilproject.it

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, andree@workbold.com)

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!

Paul 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.

Andrée Starå

@Paul Newcome

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

Paul 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.

Bassam Khalil

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.

Cheryl 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å

@Cheryl Collins

You're more than welcome!

Bassam Khalil

@Cheryl Collins

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