Help

If current formula field returns anything, then show specific text, otherwise, display nothing

Topic Labels: Formulas
Solved
Jump to Solution
901 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Sarah_MacGregor
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a pretty complex string of nested IF statements that appear as bulleted items. If the string returns anything at all, I need it to display with a title at the top “Pending Items:”. If it returns nothing at all, the title should also not appear. There is no way to add the current field title into it’s own formula, so I’m not quite sure how to approach this.

1 Solution

Accepted Solutions
Sarah_MacGregor
5 - Automation Enthusiast
5 - Automation Enthusiast

I found a solution: IF((past entire string of nested if statements ) = “”, “”, “My Title for Bulleted List Below\n” & (original entire string of nested if statements producing a bullet list))

See Solution in Thread

2 Replies 2

Hi @Sarah_MacGregor,
When you say “at the top”, do you mean the Field name, or just a top most item in a formatted string of text?

If the latter you can add a New Line in your text output with: \n

So something like this:

'This The Subject\n' &
'This is a line\n' &
'This is another line'

Gives you this:
image

Sarah_MacGregor
5 - Automation Enthusiast
5 - Automation Enthusiast

I found a solution: IF((past entire string of nested if statements ) = “”, “”, “My Title for Bulleted List Below\n” & (original entire string of nested if statements producing a bullet list))