zero value when import from excel

Mathijs Muller

We are importing data from excel into Smartsheet. In excel, we hide the zero values, but when we import the data in smartsheet, the "0" shows up. We import invoice data, sometimes these are 3 lines only, sometimes these are 10 lines. In Excel we hide any "0" value when we the linked cell is empty (so we have formula's/ linked cells for upto 10 lines, but only lines with data show up).

As we import into SMartsheet and print invoices in "generate documents" through PDF's, these PDF's show all the "0"'s.

Is there a easy way to hide the "0" values from smartsheet, so the generated documents only populate the cells with data/ values?

Genevieve P.

Hi @Mathijs Muller

It looks like @Paul Newcome already answered you on this post, here: Charts Plotting 0

Let me know if you still need help after reviewing his response!

Cheers,

Genevieve