At Risk Flag Marked triggers automatic sorting.
Hello,
My team shares a sheet that uses At Risk Flags that we have to move manually up and down on the sheet when the flags are clicked to indicate the work order is at risk.
Is there a way that we can trigger an automation so that when a flag is marked At Risk the Row automatically would get moved to the top of the sheet?
Answers
-
Hi @PB SIGN GUY,
I'm afraid, besides moving/copying a row to another sheet, I do not know of any function to move a row up or down, or trigger sorting of rows.
But, if you want to anyway move at risk rows to the top of the sheet, why not set the sheet to be sorted by risk status? Whenever a row is set to be at risk, you save it, reload the sheet and it will be at the top.
Another idea. Instead of doing all the work in one sheet, you could use a report (let's say named "at risk") filtering and sorting the content of your main sheet in a way that at risk is always on the top, no matter where the row sits in your main sheet.
Hope this helps!
Stefan
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!