Is there a way to copy just certain cells from a row to another sheet? I would like to copy 4 cells from the same row from one sheet to another sheet, each time a new row is added.
Are the cells on the same row? You can use a copy to workflow, then hide the extraneous columns.
You can either use the copy row automation or a VLOOKUP or INDEX/MATCH formula.
Would any of those options work/help?
I hope that helps!
Be safe and have a fantastic week!
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
I commented that the hide columns solutions would not work, but that turned out to be easier way to deal with this issue. I do have a question about the VLOOKUP or INDEX/MATCH formulas. It appears that a specific row needs to be identified, when I am looking for a copy function when a new row is added to the "copy from" sheet. Would either of those work for a new row copy?
Yes. Index match is a faster and more versatile version of Vlookup, but they both perform the same function, so you can use either, but I recommend learning index match.
To handle new rows you need to use column references rather than row references.
an example where the columns name is "A" would be:
I saw that it got answered already!
Let me know if I can help with anything else!
Is it not possible to just Ctrl-C and Ctrl-V the contents of a cell or cells from one sheet to another?
I hope you're well and safe!
In most cases, it should work just fine to copy/paste.
Be safe and have a fantastic weekend!
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Hi, Does anyone know if there is a way to send an alert if the value in a cell changes by more than a certain percentage? So, if I have 100 in a cell (text/number) and the value changes by over 5%, I'd like to be able to send an alert. Thanks, Vince
I'm sure this is super simple but myself and a colleague could not figure it out. I have some very simple data I need graphed for a project: Not Started, In Progress, Complete and then % Complete using the total. The pie chart for the Not Started etc. comes out correct: But when I ask it to graph just % complete, it does…
Hello, I am working on a training log for our company. I am trying to get the status color to turn green if training is completed, yellow if it is due in the future, and red if it is incomplete. I keep getting an incorrect argument. I had it working correctly when I was just doing red and green, but I really need that go…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.