Formula not showing result

Garmon D
Garmon D
edited 12/09/19 in Smartsheet Basics

I have a sheet where users enter a cost, which is then picked up via x-sheet formulas on another sheet and matched against the relevant budget code. There's another column in the original sheet that then works out via VLOOKUP what the remaining budget is. However it doesn't always show the result - the formula is still there but the cell is blank. Any thoughts?

Comments

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

    Hi Garmon,

    Maybe it has something to do with the new design and structure of Smartsheet. What browser are you using?

    Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, [email protected])

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    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.

  • It turns out I had some hidden columns where the formulass hadn't copied over, but thanks for your response!

    Garmon

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

    Happy to help!

    Glad to hear that it works now.

    Best,

    Andrée

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    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.