Text Formula Fields

ohlr
ohlr Member Posts: 30 VERIFIED MEMBER
Second Anniversary 10 Comments 5 Likes 5 Up Votes

It s great that we now have formulas for numeric and monetary fields.

I would like to be able to use formulas for text fields, to concatenate strings and build URLs.

My motivation for this request is the following:

Let's say, I want to see if company x has linkedIn ads. And I have stored their linkedIn Url in Pipedrive. I would like to have a field that adds "/posts/?feedView=ads" to that URL to be able to see if they run ads.

Example:

field 1:https://www.linkedin.com/company/pipedrive/

Formula Field: https://www.linkedin.com/company/pipedrive/posts/?View=ads

Google Sheets Equivalent:

CONCAT($LinkedInURL;"/posts/?feedView=ads")

Tagged:
1
1 votes

Submitted · Last Updated

Comments