Calculated Expression Troubleshooting

[AbiBeggs]

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? 

[Alex_Di · Accepted solution]

Hi @AbiBeggs 

Here is the contains structure   CONTAINS(findText, withinText)

[AbiBeggs]

Thank you so much!