Formula Putting a Zero in front of contact name

Options

I am using a basic if statement to try to populate contact emails into a column.

=IF([Business Unit]@row = "Field", "email1") + IF([Business Unit]@row = "Home Office", "email2") + IF([Business Unit]@row = "Distribution", "email")

Whenever the option is Distribution though, it puts a 0 in front of the result

Does anyone know what would be causing this?

Best Answer

  • Leibel S
    Leibel S ✭✭✭✭✭✭
    Answer ✓
    Options

    Try adding to the false option an empty string:

    =IF([Business Unit]@row = "Field", "email1","") + IF([Business Unit]@row = "Home Office", "email2","") + IF([Business Unit]@row = "Distribution", "email","")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!