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
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives