Error after clicking ¨Convert to Column Formula¨

System

This discussion was created from comments split from: Applying a formula for the whole column.

david.saunders

When I click the Convert to Column formula it is not letting me add anything else to the data base? Its like it just shuts off the database once you click that.

Like the above… I want to add a formula to the entire column so the formula can be continued to be implemented as we enter new data.

Suggestion?

Jason Tarpinian

What do you mean by "shuts off the database"? A column formula is just a way to make sure that every record on a sheet is calculated the same. So if a certain row doesn't have enough data, or incorrect data, to complete the calculation, it may just appear as a blank cell or some type of #ERROR until the conditions are met for the column formula to populate correctly.

Do you have a screenshot of your sheet or sample of the formula you are trying to build?