Calculated Feilds | Community
Skip to main content
J
JessicaRa4
New Member
April 5, 2024
Solved

Calculated Feilds

  • April 5, 2024
  • 1 reply
  • 548 views

I need help with a calculated field - currently its this:

 

CONCAT({DE:Client / Partner Name},"_",{DE:MKTG - What type of communication is needed?},"_",{referenceNumber},"_",{DE:MKTG - Deploy/deliver approved final communication by})
 
What I need help with is how to have workfront
1. replace characters, ex: a client or partner name has an apostrophe, we want that removed 
2. render out the dates as mmddyy so removing //
 
Any ideas? Thank you !
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 Doug_Den_Hoed_AtAppStore

 

Hi @jessicara4, 

 

I invite you to study (and bookmark) this Calculated Fields reference, particularly the REPLACE expression.

 

Regards,

Doug

1 reply

Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity AdvisorAccepted solution
Community Advisor
April 5, 2024

 

Hi @jessicara4, 

 

I invite you to study (and bookmark) this Calculated Fields reference, particularly the REPLACE expression.

 

Regards,

Doug

Terms & ConditionsAccessibility statement

Loading footer...