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

Calculating Critical Open Items per Business Analyst

SUMIFS statement not working as intended.

Trying to find duplicates in a column so I can alert the submitter and remove the row.