Help

Re: IF Formula trouble

856 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Nicola_Rudolf
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi there,

I’d like my primary field to be a formula that is Project (a linked field) + Email Type (a single select field).

If the Email Type field is empty, I’d like the primary field to be Project + Channel (a different single select field).

This is the formula I came up with:

Project & " : " IF({Email Type}=BLANK(), & {Channel}, & {Email Type})

What have I done wrong?

Thank you!

2 Replies 2
Ilan_Ben_Yaakov
6 - Interface Innovator
6 - Interface Innovator

try
Project & " : " & IF({Email Type}=BLANK(), {Channel}, {Email Type})

Thank you thank you! That worked. Brilliant.