Skip to main content
Question

Formula field error

  • June 29, 2023
  • 0 replies
  • 21 views

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
------------------------------
This topic has been closed for replies.