IF Formula trouble

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!

This topic has been closed for replies.

+7

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

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

Thank you thank you! That worked. Brilliant.

Sign up