Calculated Expression Troubleshooting | Community
Skip to main content
A
AbiBeggs
October 17, 2025
Solved

Calculated Expression Troubleshooting

  • October 17, 2025
  • 1 reply
  • 208 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? 
Best answer by Alex_Di

Hi @abibeggs 

 

Here is the contains structure   CONTAINS(findText, withinText)

1 reply

Alex_Di
Alex_DiAccepted solution
Level 3
October 17, 2025

Hi @abibeggs 

 

Here is the contains structure   CONTAINS(findText, withinText)

A
AbiBeggsAuthor
October 17, 2025

Thank you so much! 

Terms & ConditionsAccessibility statement

Loading footer...