Automate Status Color Change

Hello Everyone, I would like to make a function or an automation for a due date. I have 2 different dates and i want the status color to change if date1 is passed date 2. Is this possible? Its just for a quick visual to make sure our estimated completion date is before our actual due date. These are also subitems if it matters.

Example of what it should look like…
image

Hi @zrodgers, you can use a formula column with emojis:
image

IF({Date}>{Date 1},“:green_circle:”, “:red_circle:”)

1 Like

Thanks for the quick reply. I am getting an illegal formula error. any ideas?

heres the formula