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,
