Formula Tips are Obscuring the Actual Formula

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

Find more posts tagged with

Formulas

Project Management

Comments

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

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.

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

KPC Kelly

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

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…