Expand my Community achievements bar.

Come join us for our Coffee Break next week on top takeaways from Adobe Summit!

Calculated field with non-numeric data

Avatar

Level 2
I cannot seem to get a calculated field to recognize a formula that uses non-numeric data, so as an example: IF(CONTAINS('searchtext',Name),'Yes','No') I keep getting invalid expression, can calculated fields only use numeric comparisons? That limits their usefulness, no? Phillip Rinehart New York University
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

6 Replies

Avatar

Level 10
All is not lost, Phillip; give this a shot: valueexpression=IF(CONTAINS('searchtext', {name} ),'Yes','No') Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads

Avatar

Level 2
Not so much, this is a calculated field in a custom form so it can be reused. I keep getting 'Invalid Expression' Phillip Rinehart New York University

Avatar

Level 10
Ah; I see, Phillip -- the formula I'd provided is for a dynamic column in a view. For a calculated custom data parameter, your original formula (using 'a' instead of 'searchtext') worked for me as below: IF(CONTAINS('A',Name),'Yes','No') Noting that the calculated parameter I created is of data type "text". Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads

Avatar

Level 2
Perfect, is there a way to refer to other objects? So if wanted to use an hourtype check can that be done? p. Phillip Rinehart New York University

Avatar

Level 10
Indeed Phillip, A common reporting phrase is "you can go up, but not down"; so on a Task, you could look "up" to the (1 to 1) Name of the Project, like this: IF(CONTAINS('A',Project.Name),'Yes','No') But you cannot go "down" to the (1 to many) Hour.Hour Type. And since Workfront does not allow custom data forms on hours, you'd need to drop back to a dynamic column (as I'd first mistakenly suggested) in an Hour-based view, like this: valueexpression=IF(CONTAINS('a',{hourType}.{name}),'Yes','No') Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads

Avatar

Level 2
Well that sucks.... I'm trying to capture General time in a calculated field, it does seem that field calculations are wonky at best. I need it to do a chart. Phillip Rinehart New York University