Complete Status Automation

Platform discussions Special workflows & use cases
,
1

Hello,

I have a due date (date) column, and an “overdue vs on time” (formula) column, and a conditional coloring filter (red if its overdue and yellow if its on time within 10 days). If a task is changed to Completed (completion status column), I need to remove the conditional coloring and on time/overdue status. How can I do this?

2

@gabrielledagosta

You might try adding an IF() to your formula column to change the value when the status is Completed.

Something like this: IF({Status} = "Completed", "", )

Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday