Forum Discussion

BethanyHudson's avatar
Qrew Trainee
11 months ago

Formula field error

I'm having an issue with a Rich text formula field pulling a Combined Text Field correctly. Any time there is only one item in the combined field it doesn't pull over to my formula.

Here is the formula for the "Contracts" Rich text field:

If([Budget Classification]="2- Contractual",
"<span style='font-weight:bold'>"&(ToText([BVA Project])&"<hr></span>
\n <td " &(ToText([Combined Text Contract Document Title]))) &"<td>\n\n
<td "&[Combined Text Organization/PO]&"</td>\n\n <td "&[PO #]&"</td>\n\n
<td "&[Combined Text Contract Balance]&"</td>\n", [Expense Code])

Bethany Hudson
No RepliesBe the first to reply