Aug 15, 2018 10:09 AM
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!
Aug 16, 2018 01:31 PM
try
Project & " : " & IF({Email Type}=BLANK(), {Channel}, {Email Type})
Aug 17, 2018 06:46 AM
Thank you thank you! That worked. Brilliant.