Create a calculated field like;
IF [Student Is New] = "Yes" then "NEW" else "" END
+ " "
+ [Last Name]
1 of 1 people found this helpful
So this formula should do the trick....
IF [is student new] = 'yes' THEN 'New ' + [Student First Name] + ' ' + [Student Last Name]
ELSE [Student First Name] + ' ' + [Student Last Name]
I am very thankful for your reply, I used the second this formula bus it is not reflecting "New"
2 of 2 people found this helpful
Make sure your case of the criteria matches the data in your source data.
I.e. Simon's example has = 'yes'
If your data is really 'Yes', then you need to make sure the logic reflects that.
It could also be a good idea to use the upper function i.e. UPPER([is student new]) = 'YES'
Thank you so much, I worked. I really appreciate it.