Forum Discussion

BethanyHudson's avatar
BethanyHudson
Qrew Trainee
2 years 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