Skip to main content
Question

Formula Multi-Select Text

  • September 27, 2021
  • 0 replies
  • 171 views
Hey All,

I'm trying to make a field that says if a summary combined text field [All Deliverables] is blank, then display "N/A", otherwise show the [All Deliverables] field. Is that possible? I've tried:

If(ToText([All Deliverables]) = "" , "N/A", ToText([All Deliverables]))

but I'm getting an error around "N/A" that says "Expecting textlist but found text." I'm also unclear why I have to wrap the final [All Deliverables] in a ToText function, but if I don't I get the error "Expecting text but found textlist."

Thoughts?

------------------------------
Daniel Johnson
------------------------------
This topic has been closed for replies.

SSNJeffP
Forum|alt.badge.img+11
  • SSNJeffP
  • Registered
  • September 27, 2021
You might try making a text formula field like [All Deliverables Mirror] where the formula is just [All Deliverables] and try using that in this formula instead.

------------------------------
Jeff Peterson
------------------------------
Terms & ConditionsAccessibility statement