You need to use triple double quotes - The outer set encloses a string, the next quote serves as an escape character and the third one is included in the value entered in the cell.

=SETF(GetRef(Prop.Hosted_Type),"""Trading Partner""")

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia