Formula not filling down after pasting data from Excel

Hey guys,

I'm new to this and this is likely to have already been solved elsewhere, but I can't seem to find what I'm looking for.

my process requires that I copy data from a CSV file and paste into my sheet where the top rows have applied formulas. The formula, however, is not filling down automatically.

Any thoughts, tricks, tips are greatly appreciated.

Screen Shot 2018-11-24 at 11.54.23 AM.png

Find more posts tagged with

IT & Operations

Comments

Andrée Starå

Hi Gary,

It won't fill down If you paste information.

What are you pasting and what is it that you want to fill down?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Gary Phipps

I am downloading data from another application. When I move (at this point paste) the data into the sheet, there are two columns that reference values from another sheet. The formulas in the two columns look at the newly pasted values and the off-sheet data to calculate scores (for lack of a better word).

Is there a way to get the data into the sheet without pasting it?

You enjoy your weekend the same.

Andrée Starå

Ok.

The easiest way is probably to drag fill or use the shortcut CTRL+D or CMD+D to fill those columns down.

Would that work?

Best,

Andrée

Gary Phipps

For some reason, the CTRL-D or CMD-D (I am btw on a mac keyboard) is not working. Maybe a different browser.

Andrée Starå

That should work and the browser shouldn't have anything to do with it.

Are you selecting the cell that you want to fill down > holding shift and selecting the last cell> the cells that you want to fill will be selected?

You can also hold down shift and press the arrow down to select the cell(s) below?

More info: Fill down

I hope this helps you!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
Why are my answers not showing up when a document is generated?
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…