I have developed a large spreadsheet in which most cells are numeric and dependent on formulas in other cells in the sheet. Formulas do not auto fill when I add rows. If I delete rows, all dependent cells revert to "#Blocked" or "#Unparseable". I am somewhat new to smartsheet, so I"m guessing that I did something wrong when I set this up... I would appreciate help and I'm hoping all the effort put into the sheet has not been lost.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!