Since you're combining strings you need to put & between the different components so QB knows to combine them properly.
See below:
"Current State is" & ToText([state]) & ". Current Target Completion Date is" & [target completion date] & "."
Awesome, thank you!! Do you know if it's possible to put an if statement in there to show [state] in red, yellow, or green font depending on what the state says? Similar to this, but something that actually works:|
"Current State is " &
If((ToText([State])="red"), <span style="color:red">[state]</span>, If((ToText([State])="yellow"), <span style="color:yellow">[state]</span>, <span style="color:green">[state]</span> &
". Current Target Completion Date is " & [Target Completion Date] & "."
