IF Formula trouble


#1

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

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


#3

Thank you thank you! That worked. Brilliant.