Calculated Column | Community
Skip to main content
A
Anonymous
June 1, 2019
Question

Calculated Column

  • June 1, 2019
  • 1 reply
  • 530 views
Hello, I have entered this into a column on a task report but it's not working: displayname=Age Since Entry Date textmode=true valueexpression=IF(status='CPL', WEEKDAYDIFF(actualStartDate, actualCompletionDate), (WEEKDAYDIFF(actualStartDate, $$NOW)) valueformat=HTML Would appreciate any help or advice. Thank you. Nadia Shakfeh IEHP
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

A
Anonymous
June 4, 2019
Please try this: valueexpression=IF(status='CPL', WEEKDAYDIFF({actualStartDate}, {actualCompletionDate}), WEEKDAYDIFF({actualStartDate}, $$TODAY)) Siva Addepally
Terms & ConditionsAccessibility statement

Loading footer...