In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Hi, how can I add text to an existing text field?

Marcegon
8 - Asteroid

I am trying to set up a formula to add " / should be x" if the current status field is "Budget approved". 

 

Input

Budget approved 

 

The output would be:

Budget Approved / should be x.  

 

3 REPLIES 3
ncrlelia
11 - Bolide

Hi @Marcegon,

 

Try this 

IF [Input] = "Budget Approved"

THEN [Input] + " / should be x"

ELSE [Input]

ENDIF

 

Hope this helps.

Cheers,

Lelia

Marcegon
8 - Asteroid

Thank you so much.  This worked.  How can I change the added text to red font?  I am new in Alteryx, so I am still trying to figure things out.  Thanks again.

ncrlelia
11 - Bolide

Hi @Marcegon

 

I don't think you can change the font colour in the result, unless you are using one of the Reporting tools.

 

Cheers,

Lelia

Labels
Top Solution Authors