Calculated field with non-numeric data

[philipr52065527]

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

[Doug_Den_Hoed__AtAppStore]

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

[philipr52065527]

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

[Doug_Den_Hoed__AtAppStore]

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

[philipr52065527]

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

[Doug_Den_Hoed__AtAppStore]

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

[philipr52065527]

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