Formulas

Formulas

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!

Answers

  • Andrée Starå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, [email protected])

    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!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Paul NewcomePaul 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.

  • 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åAndrée Starå ✭✭✭✭✭
    edited 05/22/20

    @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!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.