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…

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

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