Zero Formula

Hi,

Do you want to change the color of the zero or make the cell empty?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Unfortunately you can only have either manual entry OR a formula. If you have a formula entered and manually update the cell, the formula will be erased.

If you are using a formula to do calculations to populate the cells, then wrapping the whole thing in an additional IF statement would work.

=IF(..........Original Formula........... = 0, "")

If you are using manual entry, while you can't make it blank, you can use conditional formatting to make it appear blank by setting the font color to change to the background color of the cell if it changes to zero. This would effectively "hide" the zeroes and clean up your sheet.

Not sure what your formula is but I was able to accomplish something similar. Essentially I wanted two fields to be blank after a date field in that row was in the past. So I built a formula to calculate todays date against the date the row was submitted. If the date the row was submitted was in the past I told it to populate it with the contents of my column called 'Delete'

I just never put anything in the delete column so it essentially deleted the contents of that field.

You have an extra comma tucked in that isn't needed.

Try this...

=IF(SUM({Open Positions - Per Employee Group Range 6}, {Open Positions - Per Employee Group Range 7}, {Open Positions - Per Employee Group Range 8}, {Open Positions - Per Employee Group Range 9}, {Open Positions - Per Employee Group Range 10}, {Open Positions - Per Employee Group (SG&A Range 2}) = 0, "")

@Rebecca Copley You are going to need to remove the = before SUM and then insert the SUM(CHILDREN()) into the 3rd portion of the IF statement.

=IF(SUM(CHILDREN()) = 0, "", SUM(CHILDREN()))

@Rebecca Copley That would depend on the formula(s) you are using to reference those cells. If you would like to provide some examples of the formulas you are using, I would be happy to give my opinion on whether or not I think they would be affected by a zero vs a blank.

In those cases I believe blanks are treated as zeros.

=IF(SUM([Feb 21]2:[Feb 21]6) = 0, "", SUM([Feb 21]2:[Feb 21]6))

Try that one.