Help with Formula. or automation


A co-worker made this formula in a board and says it no longer works.
IF({Status} = “Done”,IF(Days({Target Date},{Date of completion}(>0,“Done Late”,“Done On Time”),“”)
I don’t have experience with formula’s so I’m hoping someone is willing to help?
What we are trying to accomplish here, is that if the “Date of completion” is later than the “Target time”, we can label the item as Done Late. And if the date is before the Target date, it’s labeled as On Time.

Thanks in advance!

Hi @AppManIDFA,


IF({Status}="Done",IF(Days({Target Date},{Date of completion})>0,"Done Late","Done On Time"),"")

Thanks so much!