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
|