Formulas

Leslie Thomas

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.

Thanks!

Andrée Starå

Hi Leslie,

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Paul Newcome

In addition to screenshots, copy/pasting the formulas here along with descriptions of what they are supposed to be doing would be very helpful.

Leslie Thomas

Understood- thank you for your response. I did manage to 'fix' the problem with some reworking. My spreadsheet is much healthier now. Thanks again!

Andrée Starå

@Leslie Thomas

Happy to help!

Glad you got it working!

✅Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!