How to delete cells when a column has been converted to a formula column

KColvin_civic1

Hello, I am taking the course through (SmSh Uni), Writing Formulas in Smartsheet - Self Paced. I am completing an activity given to convert a formula in a cell to a column formula. The tutorial says there will be errors in two children rows and that I can delete the two cells.

Unfortunately, you can not delete a cell when the column formula is on. If I convert it back to a cell formula, I can delete the errors, but then they come back when I make it a column formula again.

The column needs to continue to be a formula for new lines as they come in.

How can I fix this? The activity did not explain this at all.

Thank you,

Paul Newcome

Can you provide a link to the activity and a timestamp for where this is within?