Help

Custom Text for Blank Field

Topic Labels: Data
597 1
cancel
Showing results for 
Search instead for 
Did you mean: 
kateymccloskey
4 - Data Explorer
4 - Data Explorer

I am unsure what formula to use.
I have a field in AT where you select the promo type. I have a view where I group things by promo type... my problem is there are instances when no promo type is selected as it does not fall into any promo type. For records where there is no promo type selected I want the word "Evergreen" to populate so that it still falls into a grouping name instead of saying "Empty"
I was thinking it might be IF({Promo Type} =BLANK(),"Evergreen") but it does not appear to be working.. can anyone help me with the proper formula?

1 Reply 1

Sure, try:

IF(
  {Promo Type} = "",
  "Evergreen"
)

Screenshot 2023-04-07 at 5.31.55 PM.png