Limitations to a sheet?

Hello, I'm in the process of automating a tracking sheet, and it will no longer allow me to copy and paste the formulas into the rows- see screen shots below- it stops at row 1400

The formulas are:

=IF(ISDATE(Start1375), "Complete", IF(ISBLANK(Start1375), "In Progress"))

=IF(Status1375 = "in progress", [Panel S/F]1374, 0)

=IF(Status1375 = "complete", [Panel S/F]1374, 0)

Thanks!

Find more posts tagged with

Accepted answers

Paul Newcome

Hmm... That's very odd. Try logging out. Then clear your cookies and cache. Then log back in again. See if that helps.

All comments

Paul Newcome

Going back through, I just noticed this part...

"it stopped at 1400 no matter what, I couldn't drag down, paste, or even type in a new equation. "

Was the sheet frozen? Can you expand on the bold portion?

Sean Murphy

re-typing the formula that I'm attempting to paste I think is a better way of saying it

Paul Newcome

I just saved it. Here are the steps...

I highlighted from Duration1866:[Task SF in Progress]1871.

I then used CTRL+C to copy.

I clicked on Duration1875.

I then used CTRL+V and it pasted just fine.

Paul Newcome

re-typing the formula that I'm attempting to paste I think is a better way of saying it

I'm still not sure I follow exactly what you mean. It wouldn't let you edit the cell at all, or it just would not take the formula?

Sean Murphy

What I meant, is it wouldn't take the formula, but it just took it so disregard that statement. After trying a few different things, it's letting me paste one cell at a time, but that's it.

Sean Murphy

Also, on the published sheet, it's not allowing me to copy and paste at all.

Paul Newcome

Hmm... That's very odd. Try logging out. Then clear your cookies and cache. Then log back in again. See if that helps.

Sean Murphy

Ha! amazing, that did the trick! Thanks, Paul!

Paul Newcome

Happy to help! 👍️

Generally speaking... If it works for one person and not another, then it is probably time to start looking at the browser instead of the data.

Glad we were able to get it working for you. Sorry I didn't think of it sooner.

Genevieve P.

Hi! Wow, I missed a lot - but so glad to see you worked it out. Thanks, Paul!!

Paul Newcome

@Genevieve P Sure thing! Thanks for looping me in with your vote of confidence. Haha. I'm glad I didn't let you down.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.