This forum is closed. Thank you for your contributions.

Sign in

Microsoft.com

Microsoft

Remove From My Forums

Concatenating field contents including Enterprise Custom Field

Question
0

Sign in to vote

Is it possible to define an Enterprise Custom Field as the concatenation of two other fields, one of which is itself an Enterprise Custom Field?

I've got "Customer Name" as an Enterprise Custom Field (lookup table) and want my new ECF to be:

Customer Name - Project Name

Monday, February 23, 2015 9:17 PM

Answers

1

Sign in to vote
Hello,

Yes this is possible, create a project level custom field based on a text field and set it to use a formula. In the formula box put:

[Customer Name] + ' - ' + [Project]

That will include a hyphen between the two fields.

Paul

Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads
- Edited by PWMatherMVP Monday, February 23, 2015 9:47 PM typo
- Proposed as answer by Guillaume Rouyre [MBA, MVP, MCC]MVP Tuesday, February 24, 2015 7:01 AM
- Marked as answer by PWMatherMVP Thursday, March 26, 2015 9:34 AM
Monday, February 23, 2015 9:40 PM