Status Colours - comparing dates

Phil Collins

Hi

Quite new to SS, but have been tasked with trying to update a current sheet to show a colour status column.

I have 2 columns which hold dates, with some of the data been pulled in from other sheets, thats need comparing. If someone can help with the formula to show Green, amber, red status dots depending on the below criteria.

The status column needs to show green if the date in "Supplier Actual confirmed dispatch date" is before the date in "Dispatch Date given on OA"

The status column needs to show amber if the date in "Supplier Actual confirmed dispatch date" is the same date in "Dispatch Date given on OA"

The status column needs to show red if the date in "Supplier Actual confirmed dispatch date" is after the date in "Dispatch Date given on OA"

Really stuck with where to start with, and been looking on here for answers but couldnt get anything to work.

Please help.

Thanks Phil

Andrée Starå

Hi @Phil Collins

You'll need to use one or multiple so-called helper columns and then reference it in the Conditional Formatting rules.

Make sense?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help 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! 

Andrée Starå

Hi @Phil Collins

You'll need to use one or multiple so-called helper columns and then reference it in the Conditional Formatting rules.

Make sense?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help 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!