How do you enter a long formula?

Hello,

I have quite a long formula, I wrote it in Word... When I copy and paste, the cells used in the formula are not highlighted, so I think the program doesn't recognize them. Therefore, I am copying my formula by hand.

However, when I am at about the second or third line and I click on a cell to use it in the formula, the formula entry box keeps disappearing. Cells used in the formula are still highlighted in the sheet, but I cannot do anything anymore but refresh the sheet. Then, my changes to the formula are gone.

One I still saw the formula entry box, but it was half out of the screen and I couldn't see what I was writing...

Does anyone have any tips on how to deal with long formulas?

Find more posts tagged with

Formulas

Cell linking

Accepted answers

All comments

Paul Newcome

It sounds like you may have a syntax issue. Are you able to post the formula? I have put together quite a few very long formulas including formulas that exceeded the 4,000 characters per cell limit with no issue (other than the limit not letting me save).

Andrée Starå

Hi @VeraB

I hope you're well and safe!

Yes, Word and other applications can add strange characters, so I'd recommend using Notepad or something similar.

I hope that helps!

Be safe, and have a fantastic week!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.