Calculated Expression Troubleshooting | Community

Solved

Calculated Expression Troubleshooting

Forum|Forum|6 months ago
October 17, 2025
1 reply
215 views

Hi all,

I'm sure I'm missing something super simple but I'm trying to use a calculated field, formatted as a number, to pull in the difference between our planned start date and actual completion date on our task reporting form for tasks named review. The formula I'm using is:

IF(CONTAINS({name},"review"),WEEKDAYDIFF({plannedStartDate},{actualCompletionDate}),"")

but it isn't working as expected. Does anyone have any suggestions on how to further troubleshoot?

Workfront

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Alex_Di

Here is the contains structure CONTAINS(findText, withinText)

Alex_DiAccepted solution

Level 3

Here is the contains structure CONTAINS(findText, withinText)

Thank you so much!