zero value when import from excel
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?
Answers
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives