Formula to copy specific rows/cells (including blank cells) to another sheet

Jonna Critchley · 10/20/20

I need to take the above highlight area from this above sheet, to the highlight area in the below sheet...

I've tried so many formulas and keep getting errors =\

Any help?

Andrée Starå · 10/20/20

Hi @Jonna Critchley

Why do you need that exact area and is it a one time thing? Will there be new rows added to the destination sheet?

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Jonna Critchley · 10/26/20

Hi There Andree,

I'm not sure I can share with you, however, here is the process that I'm trying to complete...

The first screenshot (sheet #1) is a weekly report that is updated by smartsheet form, so that each time a person submits their weekly report by form, it populates on the next line below the last entry.

I've been asked to provide a current (live) update of that time for each current quarter (right now, Oct-Dec 2020).

I'd like to populate the second screenshot (sheet #2) with the next 12 lines (12 weeks worth of weekly reports) from the first screenshot sheet (sheet #1). This way I can have it automatically calculate the total (see the bottom grey row on sheet #2) for the quarter. Unfortunately, it's not as easy as linking cells as SmartSheet doesn't allow for linking of empty cells (just saying, this should be a feature).

That total is linked to a SmartSheet that is in turn what updates the Dashboard that shows the current quarter update of time and money.

Hopefully this makes sense!

I read that I need to do an INDEX and MATCH, but each time I try it an error =\

Jonna Critchley · 11/02/20

I think I was supposed to @ you?

@Andrée Starå

My apologies, new to all of this!

Andrée Starå · 11/11/20

@Jonna Critchley

No worries!

I'd recommend setting up a cross-sheet formula structure with VLOOKUP or INDEX/MATCH and match it with an Autonumber.

Make sense?

Would that work/help?

Jonna Critchley · 11/12/20

@Andrée Starå I tried that and kept getting an error, I was hoping to get assistance with that =)

Andrée Starå · 11/17/20

@Jonna Critchley

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Formulas and Functions

Formulas and Functions

Formula to copy specific rows/cells (including blank cells) to another sheet

Answers

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

Counting occurrences of values in a multi-select dropdown list

How would I write a formula to locate duplicates in 1 column and the difference in another column.

#NO MATCH result but not for identical formulas