Forum Discussion
Hi Bhargavi,
Here is a rich text formula you can use!
If(ToText([Workstream]) = "", "",
"<span style='color: #FF0000'>" & "• " & "</span>" & Part(ToText([Workstream]), 1, ";") & "<br>"&
"<span style='color: #FF7F00'>" & "• " & "</span>" & Part(ToText([Workstream]), 2, ";") & "<br>" &
"<span style='color: #FFFF00'>" & "• " & "</span>" & Part(ToText([Workstream]), 3, ";") & "<br>" &
"<span style='color: #00FF00'>" & "• " & "</span>" & Part(ToText([Workstream]), 4, ";") & "<br>" &
"<span style='color: #0000FF'>" & "• " & "</span>" & Part(ToText([Workstream]), 5, ";") & "<br>" &
"<span style='color: #4B0082'>" & "• " & "</span>" & Part(ToText([Workstream]), 6, ";") & "<br>" &
"<span style='color: #9400D3'>" & "• " & "</span>" & Part(ToText([Workstream]), 7, ";") & "<br>" &
"<span style='color: #964b00'>" & "• " & "</span>" & Part(ToText([Workstream]), 8, ";") & "<br>" &
"<span style='color: #008080'>" & "• " & "</span>" & Part(ToText([Workstream]), 9, ";") & "<br>" &
"<span style='color: #FFC0CB'>" & "• " & "</span>" & Part(ToText([Workstream]), 10, ";"))
The only changes you should need to make are the colors of your bullets by changing the hex code. This example is for 10 entries in a multi-select, but if you need more simply add more lines in the same format. Your result should look similar to this:
Please let me know if you have any trouble with it!
------------------------------
Tyler Foster
Associate Developer
Synctivate Inc.
------------------------------
Will be waiting for the response, if someone could help out on this really appreciate the help:). Thanks in advance.
------------------------------
Bhargavi Katepalli
------------------------------