Skip to main content
New Member
Oct 17, 2025 1:25 PM UTC
Solved

Calculated Expression Troubleshooting

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? 
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Alex_Di
Alex_DiAccepted solution
Level 3
Oct 17, 2025 1:37 PM UTC

Hi @abibeggs 

 

Here is the contains structure   CONTAINS(findText, withinText)

2 replies

Alex_Di
Alex_DiAccepted solution
Level 3
Oct 17, 2025 1:37 PM UTC

Hi @abibeggs 

 

Here is the contains structure   CONTAINS(findText, withinText)

Translate
AbiBeggsAuthor
New Member
Oct 17, 2025 1:41 PM UTC

Thank you so much! 

Translate