Text Formula, Concatenate fields
I am having a terrible time creating a field to concatenate several fields based on conditions. First, should I use a text formula or rich text? Neither seem to work. I have a combination of multiple ...
Forum Discussion
Something like this (this could be formatted differently depending on whether the "field name" values are the same whether it's a Risk or Issue):
If( [Task Type]="Project", If( [Risk], "Risk: Project " & [field name] & " " & [field name], [Issue], "Issue: Project " & [field name] & " " & [field name] ) )