Expand my Community achievements bar.

IF expression in calculated field


Level 2

Hello! Is it possible to use predecessor planned completion date in an IF expression.

We are trying to create an expression that will highlight a line in red if the planned completion date does not match the predecessor planned completion date.

IF(Planned Completion Date!=Predecessor Planned Completion Date,"Yes","No") is a invalid expression. Am I missing something?

Thank you!

1 Reply


Level 10


This works in an assignments report column:

displayname=Date Match





That being said, I have not been able to successfully use text based expressions (IF, CONCAT, etc) on date/time calcs in a form. If you even DID get it to work, it would not honor the standard time zone rules as all text based calcs use the default time zone when referencing dates.

This doesn't say invalid expression but it still doesn't work:

IF(Planned Completion Date=Actual Completion Date,"yes","no")

I suspect it's because the predecessor date is a reference and form calc won't even entertain that.

Because Workfront hasn't remedied this, I would suggest a report-based calculation rather than form-based.

But if you do get anything to work, I'd love to hear how it's done.