Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

If cells used in formula are blank, then leave the formula cell blank

Options
rbarnes15506
edited 12/09/19 in Archived 2017 Posts

I have a =AVG formula in a column that gets its info from 2 other Columns.  If the two other cells are blank, the column with the =AVG formula populates with a #DIVIDE BY ZERO error message.

Is there a way to have the Average Column display empty if the other two are empty.

Thanks

Comments

This discussion has been closed.