Formula Multi-Select Text
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 t...
Forum Discussion
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
------------------------------
------------------------------
Jeff Peterson
------------------------------
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
------------------------------
------------------------------
Daniel Johnson
------------------------------
- Is there a reason to do this in a formula multi-select field instead of formula text?
------------------------------
Jeff Peterson
------------------------------- Try this formula:
Split(List(" ; ",
If( [All Deliverables]=null, "N/A"),
If( [All Deliverables]<>null,ToText([All Deliverables]))))
vs
------------------------------
Jeff Peterson
------------------------------- That worked! Thanks Jeff!
------------------------------
Daniel Johnson
------------------------------