Cell in a report that has no data is displaying a "0" - how to remove this?

MelindaD · 07/06/23

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.

Genevieve P. · 07/07/23

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

Paul Newcome · 07/10/23

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.

Paul Newcome · 07/06/23

How are you currently populating those cells in the source sheet?

MelindaD · 07/07/23

They're just empty cells in the source, no data, no formula.

Paul Newcome · 07/07/23

You may want to reach out to support then. I've not seen that before and can't replicate it.

Genevieve P. · 07/07/23

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

Paul Newcome · 07/07/23

@MelindaD I may have misunderstood... When you say "report", are you talking about an actual Smartsheet report pulling from rows in a Smartsheet sheet?

MelindaD · 07/08/23

https://community.smartsheet.com/discussion/comment/384157#Comment_384157

Yes, that's right

MelindaD · 07/08/23

https://community.smartsheet.com/discussion/comment/384157#Comment_384157

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.

Paul Newcome · 07/10/23

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.

MelindaD · 07/10/23

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 😀

Cell in a report that has no data is displaying a "0" - how to remove this?

Best Answers

Answers

Help Article Resources

Categories