Hi! I am relatively new to Smartsheet and trying to figure out how to program a sheet I am working on. I have one sheet holding many rows, each row representing a different project. For each project, the user is able to mark the priority as high, medium, or low, using the built in Smartsheet symbols.
The goal is to make it so when the user selects "high priority," it automatically moves the row to the top of the sheet. Is this possible? I have done some research but come up empty. Any help is much appreciated. Thank you!