Discussions

Expand all | Collapse all

Formula Multi-Select Text

  • 1.  Formula Multi-Select Text

    Posted 26 days ago
    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
    ------------------------------


  • 2.  RE: Formula Multi-Select Text

    Posted 26 days ago
    Edited by Jeff Peterson 26 days ago
    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
    ------------------------------



  • 3.  RE: Formula Multi-Select Text

    Posted 26 days ago
    The formula field is a Formula - Multi-select Text field. [All Deliverables] is a Multi-select Text field.

    ------------------------------
    Daniel Johnson
    ------------------------------



  • 4.  RE: Formula Multi-Select Text

    Posted 26 days ago
    The mirror solution didn't stop an error somewhere in the formula. To save the text field I still have to use to ToText function on the summary combined text field. Doing that and then using it in the original formula still shows the same error around "N/A"



    ------------------------------
    Daniel Johnson
    ------------------------------



  • 5.  RE: Formula Multi-Select Text

    Posted 26 days ago
    Is there a reason to do this in a formula multi-select field instead of formula text?

    ------------------------------
    Jeff Peterson
    ------------------------------



  • 6.  RE: Formula Multi-Select Text

    Posted 26 days ago
    Edited by Jeff Peterson 26 days ago
    Try this formula:

    Split(List(" ; ",

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

    vs



    ------------------------------
    Jeff Peterson
    ------------------------------



  • 7.  RE: Formula Multi-Select Text

    Posted 25 days ago
    That worked! Thanks Jeff!

    ------------------------------
    Daniel Johnson
    ------------------------------