Status Colours - comparing dates

Options

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

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!