Task Health, not available in automation

Laura G

Hi

I am setting up an automation for a due date to trigger the Task Health to change colour. It doesn't look like this is available in the action "change cell value, is that true?

Kind regards

Melissa Yamada

Hi @Laura G

You should be able to write a formula to accomplish this. Something like

=IF(DueDate@row<Today(),"Red","Green")

or any other criteria you are looking for.

Laura G

Sorry this doesn't work. I have added this formula to a new column but it says unparseable.

Matt Johnson

Hi @Laura G

Melissa's formula is correct. In her example "DueDate" would be the name of the column so your column name might differ slightly. Maybe try typing the formula into the cell you want and don't do a copy and paste. Sometimes that helps me in similiar situations. Let us know if its still not working.

Thanks, -Matt

Laura G

Thanks Matt, i made sure to check the spelling. I will type in manually and see if that helps. Thank you