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

MelindaD

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.

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

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

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

MelindaD

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

Paul Newcome

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

Genevieve P.

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

@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

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

Yes, that's right

MelindaD

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

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

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 😀