If/Then Display Text

[JohnBu2]

I am trying to create a field on a report that will display certain text based on a condition test. I do not get an error message or a any results in the column. I have tried to use a simple single IF statement and still get the same results. The below statement is what I am trying to get to work. I have considered a case statement. I have also tried the {} around the field names I am testing and camel case with no luck. I am extremely new to Workfront, so I am at a disadvantage with the specific syntax. displayname= Priority Rating valueexpression=IF(Major Client="Yes"&&Is the Client at risk?="Yes","2-High", IF(Major Client="Yes","3-Medium", IF(Is the Client at risk?="Yes","3-Medium"))) John Burns

[JohnBu2]

I have also tried the following and simplified the If with no results as well. displayname=Column textmode=true valueexpression=IF({DE:majorClient}="Yes","3-Medium") valueformat=HTML John Burns

[SkyeHa]

hey John, kudos for going back and trying something simpler to see if that would work. Along those notes, have you tried valueexpression=IF({DE:Major Client}="Yes","3-Medium") (I noticed you had a camelCase in there and I think that doesn't need to be there) -skye

[JosueMe]

HI John, An IF statement always requires three parts 1. Comparison to check 2. Result when 1 is true 3. Result when 1 is false 2 and 3 can be other IF statements if you want, be each IF statement needs all three components. You do not have all three for all three IF statements. Also, since you're referencing a custom field, you still need the DE: and the {} such as {DE:Field Name} Please remember to use the correct capitalization for your custom field as it exists. Josue Mendez

[pco88]

To troubleshoot, see if you can pick up the custom field DE:majorClient on a separate column on your report. Just so you know you are indeed expecting the exact/correct "Yes" for that particular row. Also, making sure that you can actually pick up the DE:majorClient as a column on your report. Then for IFs, I usually also use contains. "sample" is my custom field. displayname=test linkedname=direct namekey=sample querysort=DE:sample textmode=true valueexpression=IF(CONTAINS("3",{DE:sample}),"TEST",{DE:sample}) valueformat=HTML Regards. Polly Co