Formula Tips are Obscuring the Actual Formula

Kate F.
Kate F.
edited 12/09/19 in Formulas and Functions

Hello,

Could anyone provide a trick to move the formula tip dialogue box?  I am getting an Unparseable error message, but I cannot see the formula to check the syntax (see attached screen shot). Are other people facing this problem?  Is it browser specific?

 

I am working around this by copying and pasting parts of my formula to other cells and then rejoining, but this is a cumbersome task.

 

Any help is very much appreciated.

2018-09-18 10_37_10-TCO Project Schedule - New - DRAFT - Smartsheet - Cant see formula details.png

Comments

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

    Hi Kate,

    One workaround could be to edit the formula in your text editor of choice.

    I hope this helps you!

    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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    It's a hit or miss problem that I have brought to the attention of Smartsheet. Sometimes it does. Sometimes it doesn't. I have tried all kinds of different mess, but haven't been able to figure out one specific thing that causes it to happen.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • L_123
    L_123 ✭✭✭✭✭✭

    This is worse than I've ever seen it. I think they made some sort of mistake moving something around. Until they fix it we need to use text editors like Andree said

    Capture.PNG

  • KPC Kelly
    KPC Kelly ✭✭
    edited 10/11/18

    This continues to be annoying, I've noticed. This is not ideal, but one workaround is to make the cell font incredibly large. In this way, the formula tip dialogue box covers only a small portion of the formula. A bonus of doing this is that once you return the font to a more normal size, the dialogue box may stay in a more favorable position (as shown in the second screenshot below).

    Example 1.PNG

    Example 2.PNG

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!