How to set up move row automation with formulas
I currently have a formula in place to "star" a row on sheet A when a unique identifier # from sheet A is added to sheet B. Then, I would like to move the row from sheet A to sheet C after the "star" is highlighted.
I read the statement below in the smartsheet Automation article:
"Actions that will automatically modify the sheet cannot be triggered by inbound cell-links or cross-sheet formulas."
Any way to work around this or use a specific formula?
Thank you!
Answers
-
Hi @Valerie Javurek
Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
I hope you're well and safe!
One idea could be to copy the row that gets starred to the other sheet and then have a so-called helper column to check for duplicates, and then that would trigger the move row workflow.
Would that work/help?
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!
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.
-
Hi @Bassam.M Khalil & @Andrée Starå,
Thank you for your responses!
This is Sheet A. When a new form entry is implemented into the sheet, the SSPID# is generated.
Anytime a project becomes Inflight, a new form submission is entered into Sheet B below. The SSPID # is entered into the form and the status default value is "PO Received."
We have a formula/vlookup in place that whenever the status in Sheet B is "PO received" it will star the inflight column on Sheet A.
The below automation is in place, however, whenever the inflight column becomes starred, the row does not move.
I found an article that talks about trigger blocks and this is what was stated at the bottom:
Is there a way I can successfully run this process with a workaround?
Thank you for your help!
-
Hi @Bassam Khalil & @Andrée Starå,
I appreciate both of your responses! Below is a breakdown of the process I am trying to put in place but can't seem to find a workaround.
This is Sheet A. When a new form entry is implemented into the sheet, the SSPID# is generated.
Anytime a project becomes Inflight, a new form submission is entered into Sheet B below. The SSPID # is entered into the form and the status default value is "PO Received."
We have a formula/vlookup in place that whenever the status in Sheet B is "PO received" it will star the inflight column on Sheet A.
The below automation is in place, however, whenever the inflight column becomes starred, the row does not move.
I found an article that talks about trigger blocks and this is what was stated at the bottom:
Is there a way I can successfully run this process with a workaround?
Thank you for your help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!