Automation of moving data in the same sheet
Hello!
Does anyone know how to make an automation of moving data from one column to another within the same sheet? Or have same problem as me?
Thanks in advance.
Answers
-
I have tried and tried but have never found a way to get automation to take the value of 'cell 1' and use it to set the value of 'cell 2'.
You COULD go through a crazy in-depth process of qualifiers and stuff to make it "look" like it was doing it but I have not gotten it to work though.
What you might be able to do would be to have a second sheet in the background that has formulas and automation set up that (kind of) accomplish what you are wanting and then have the first sheet reference those new cells.
Let me know if this sounds like it would be worth looking into and I can guide you a bit.
Hope this helps!
Heath Hilton
-
I hope you're well and safe!
Please have a look at my post below with a method I developed.
More info:
Would that work/help?
I hope that helps!
Have a fantastic week & Happy New Year!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. 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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!