Post

4 followers Follow
0
Avatar

Text Formula

Why is this giving me an error?

What does the error even mean???

Umesh Shah Answered

Official comment

Avatar

Hi Umesh,

 

1. Contains() returns a boolean value and your field type is text.

2. When using a contains() you should make sure you run it on Strings fields/variables. $Project is a reference to object field, in that case it would make more sense to use the $Name nested field - Contains($Project.Name,'Business Plan', TRUE)

 

What is your expected result? What are you trying to accomplish with that calculated field?

 

Regards,

Tamir

Tamir Avital
Comment actions Permalink

Please sign in to leave a comment.

2 comments
Date Votes

0
Avatar

The Contains() function text can only be a string, not a reference to an object like $Project. Try using $Project.name which is a text field rather than $Project which is a reference to an object field. 

Evan Peterson 0 votes
Comment actions Permalink