BethanyHudson
2 years agoQrew Trainee
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
------------------------------