Formula Rich Text field containing fields

Question

I am trying to create a Rich Text Formula field that will display as fields are completed. It's meant to show the user what a notification will look like when sent. However, the field references in my formula field are not displaying the text typed, just the field name. I am unsure what I need to do to get the typed text showing in place of the field name. Here is my formula:"

Attached is [Call Forecasting Description] [Call Forecasting Purpose] and will be distributed by [Call Forecasting Distribution].

Please share this information with your teams as appropriate. If you have any questions, please contact [Assigned To].

When is the communication going out?
*This will be sent to [Call Forecasting LOB] [Call Forecasting Audience].
*Exceptions - [Call Forecasting Exceptions].

When is the communication going out?
*The estimated mail drop is [Desired Due Date].

Thank you

"Here is the output on the form:Call Forecasting Email Preview Attached is [Call Forecasting Description] [Call Forecasting Purpose] and will be distributed by [Call Forecasting Distribution]. Please share this information with your teams as appropriate. If you have any questions, please contact [Assigned To]. When is the communication going out? *This will be sent to [Call Forecasting LOB] [Call Forecasting Audience]. *Exceptions - [Call Forecasting Exceptions]. When is the communication going out? *The estimated mail drop is [Desired Due Date]. Thank you Any help is appreciated. I am so close but can't seem to figure out the correct syntax to use. Thank you!------------------------------Amy Gosz------------------------------

MarkShnierYou · Answer

All you need to do is to end the quotes when you need to insert a field name, and then use the & character for concatenation."

Attached is " & [Call Forecasting Description] & " " & [Call Forecasting Purpose] & " and will be distributed by " & [Call Forecasting Distribution] & "

Please share this information with your teams as appropriate. If you have any questions, please contact " & [Assigned To] & ".

When is the communication going out?
*This will be sent to " & [Call Forecasting LOB] & " " & [Call Forecasting Audience] & ".
*Exceptions - " & [Call Forecasting Exceptions] & ".

When is the communication going out?
*The estimated mail drop is " & ToText([Desired Due Date]) & ".

Thank you

"------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Sign up

Login to the community