Removing Rows at Bottom of Sheet - Affecting Formulas on Dashboard

02/11/19 Edited 12/09/19

There are about 10 blank rows at the bottom of my sheet that keep coming back, even after I delete them. I either need to know how to permanently delete them or how to adjust my formulas to not include them because they are affecting our dashboard results.

Any help or advice anyone has is welcome.

Thank you!

Comments

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Adrienne,

    Unfortunately, there isn't a way to don't have those 10 blank rows in the bottom.

    How is it affecting your dashboard? What formulas are you using?

    Hope that helps!

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Hi Andrée,

    This is affecting me now as well. My formulas look for "" in an "Assigned to" column, so we know how many projects are currently unassigned.  Any way to address this? The issue is inflating the number on our dashboard.

    Thank you

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Brian,

    Depending on the structure of your sheet you could subtract in the formula by the same amount.

    Would that work?

    I hope that helps!

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    work-bold

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Brian,

    Did you get it working or do you still need help?

    Have a fantastic week!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • ShileShile
    edited 01/07/22

    I have the same issue, is there a workaround?

Sign In or Register to comment.