Convert to Column Formula


I am adding a simple "IF" formula to a field, but when I convert to entire column, it erases all the values on the rest of the fields in that column. This doesn't make sense because the other values that are being erased are not related to the "IF" formula I am creating.

Is there a way to apply a formula to an entire column without losing the data that is already in other fields not related to the formula I am trying to create?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!