Error after clicking ¨Convert to Column Formula¨

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

Answers

  • Jason Tarpinian
    Jason Tarpinian Community Champion

    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?

    Jason Tarpinian - Sevan Technology

    Smartsheet Aligned Partner

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!