How do I bold part of a custom formula in a visio field?

Ben-3272 21 Reputation points
2020-09-28T14:57:22.403+00:00

I created an org chart linked to a data source, and I'm using a custom formula to display each person's position and name in a basic rectangle shape. I would like to make the position bold, but not the name. I tried <b>text</b> but it didn't accept it. Is there a way to apply formatting in a custom formula?

This is the current formula:
=Prop.Title&CHAR(10)&CHAR(10)&Prop.DisplayName

The end result would be something like this:

----------------
---Bob Smith--
----------------
Visio Management
Visio Management
Visio: A family of Microsoft products used to create diagrams and vector graphics.Management: The act or process of organizing, handling, directing or controlling something.
251 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Hua-MSFT 27,641 Reputation points
    2020-09-29T05:54:23.97+00:00

    @Ben-3272 ,

    The result of the current formula shown as a whole, and we could not just select the part of it.

    I am afraid you need to split the original custom formula into 2 formulas. Then you may just bold the result of position.


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.