Copying a row from one sheet to the other
Hello,
I am trying to copy a row from one sheet to another through automation. When a date or a run name is entered into a row, it will send that row to a data sheet I created. From that data sheet, i have a third sheet that uses vlookup to pull the dates and run name over to a calendar based sheet.
My issue is that when i copy the row over, it always puts it at the bottom of the page. I want it to be added to the top of the page like a form can do.
or if cannot get the copy row to go to the top of the page, i need the Vlookup formula to read duplicates from the bottom of the page up instead of top down.
any suggestions?
thanks
Scott
Best Answers
-
Instead of a VLOOKUP, you can add to the sheet you are searching a Created (date) column then use a JOIN/COLLECT/MAX combo to pull the most recent row.
-
@Andrée Starå @Paul Newcome Thanks for the help guys. This is the formula I came up with to make it work I think. It is bringing over the values I am looking for.
=MAX(COLLECT({8 - Texas Shuttle Tracker Dispatch Board Range 1}, {8 - Texas Shuttle Tracker Dispatch Board Range 2}, "TEXAS SHUTTLE")
This is the first time working with the MAX and COLLECT functions. I am going to have to get to know this better, makes it much easier.
Thanks again!
Scott
Answers
-
Hi Scott,
Unfortunately, it's not possible at the moment to have the row added to the top, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment
Can you 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@getdone.se)
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post 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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Instead of a VLOOKUP, you can add to the sheet you are searching a Created (date) column then use a JOIN/COLLECT/MAX combo to pull the most recent row.
-
@Paul Newcome Good idea! 👍️
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks Ill try that and let you know!
-
-
@Andrée Starå @Paul Newcome Thanks for the help guys. This is the formula I came up with to make it work I think. It is bringing over the values I am looking for.
=MAX(COLLECT({8 - Texas Shuttle Tracker Dispatch Board Range 1}, {8 - Texas Shuttle Tracker Dispatch Board Range 2}, "TEXAS SHUTTLE")
This is the first time working with the MAX and COLLECT functions. I am going to have to get to know this better, makes it much easier.
Thanks again!
Scott
-
Glad you were able to get it working! Happy to help. 👍️
The COLLECT function definitely brings a lot of flexibility to a lot of other functions.
Please don't forget to flag the most appropriate response(s) as "accepted" so that others searching for a similar solution can know that one may be found here.
I had this sent to me by someone, and I think it may be appropriate here...
-
@SRenner Excellent! Happy to help and glad you got it working!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Paul Newcome Haha! Good one!
🤣
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives