odd behavior - unwanted "0" showing up after form submission

edited 12/09/19 in Smartsheet Basics

I have a formula in a column called "Template" that looks like this:

[apple]1 + [pear]1 + [grape]1

Three different forms allow the user to select a dropdown value for one of those dropdown types. For example, on form one, you can select "red" from the apple dropdown. On form two, you can select "purple" from the grape dropdown.

Under the Template column in my sheet, this is showing up as, "0red" for a submission from form one, or "0purple" for a submission from form two.

Any idea how I can get rid of the unwanted "0"?



  • Taylor F
    Taylor F Employee Admin


    The formula must be seeing the empty cells as a 0 instead of a null value. I am not able to reproduce this on one of my sheets.

    If you could, please submit a support entry here: https://help.smartsheet.com/contact. You can provide the link to this post to make it easier to explain in your submission.




  • Chris McKay
    Chris McKay ✭✭✭✭✭✭

    Hi Andy,

    In the meanwhile, you could use the following to strip out the zeros: 

    =MID([apple]1, 2, 10) + MID([pear]1, 2, 10) + MID([grape]1, 2, 10)

  • andygt02

    Thanks for the help! 

    I tried the solution above, and while it does strip the leading character, the 0 still remains. 

    For the first two cells, it's clear, but beyond that I'm always getting the "0". Any thoughts?