AUTOMATICALLY MOVE A ROW WITHIN THE SHEET WHEN A CONDITION IS MET?
HI,
I need to automatically move the rows that have reached a date within the same sheet into the next calendar year.
When Agreements expire they have to be reviewed for the following year, I'd like to do this automatically.
Is it possible to maintain the information within the same sheet?
Thanks
Answers
-
Hi Ileana,
Unfortunately, it's not possible at the moment to move the rows automatically in the same sheet, but it's an excellent idea!
Great idea! That would be a great addition to Smartsheet features.
As a possible workaround, you could maybe use the Smartsheet API or a 3rd party service like Zapier to make it work.
I'd recommend moving them to another sheet and maybe move them back again, so they move to the bottom of the main sheet.
Would that work?
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.
-
I agree the ability to move rows within a sheet is a great idea and would greatly enhance funtionality.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!