Cell in a report that has no data is displaying a "0" - how to remove this?
We're pulling a report where many of the cells are empty. However on the report there is a 0 showing in all the cells. I've attached a screenshot to show some of the cells in question. It's an issue throughout the entire report/sheet, not just the one column shown.
How do we remove the 0 so the cells are actually empty/blank without changing or deleting any forumulas in other cells?
To be honest, I'm not sure if this is a formula issue or formatting, so my apologies if I've put this question in the wrong area.
Best Answers
-
Hi @MelindaD
What is the source? Are you importing an Excel file into Smartsheet?
One way to clear these out would be to set up a Clear Cell workflow for that specific column if the cell = 0.
See: Clear the contents of a cell with the clear cell value action
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Ah. Ok. In that case I would start with @Genevieve P.'s suggestion. If that is not possible because of some cells actually needing to contain the zero with other cells being blank, you may end up needing to adjust the excel file itself.
Answers
-
How are you currently populating those cells in the source sheet?
-
They're just empty cells in the source, no data, no formula.
-
You may want to reach out to support then. I've not seen that before and can't replicate it.
-
Hi @MelindaD
What is the source? Are you importing an Excel file into Smartsheet?
One way to clear these out would be to set up a Clear Cell workflow for that specific column if the cell = 0.
See: Clear the contents of a cell with the clear cell value action
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
@MelindaD I may have misunderstood... When you say "report", are you talking about an actual Smartsheet report pulling from rows in a Smartsheet sheet?
-
Yes, that's right
-
Ugh.... I was initially told it was a report pulling from Smartsheet sheet, but it's not. It's a Smartsheet sheet after having data imported from excel. The cells were blank in excel, but when they imported they've put a '0' in the cell.
-
Ah. Ok. In that case I would start with @Genevieve P.'s suggestion. If that is not possible because of some cells actually needing to contain the zero with other cells being blank, you may end up needing to adjust the excel file itself.
-
Thanks very much for the suggestions and help. I think we're going to have to go back to the original excel sheet and look at the formatting that's on there. It didn't help that I was given the incorrect information to start with unfortunately. Thanks @Genevieve P. and @Paul Newcome 😀
Help Article Resources
Categories
Check out the Formula Handbook template!
