Smartsheet Basics

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

Workaround to sort Report rows manually?

✭✭✭✭✭

Anyone have a workaround solution to sort Report rows manually?

For example, we need to put priority items at the top - but that priority is manually adjusted (not logical). Using a 'Priority' column to sort by doesn't work, because they want to move around and see how it's adjusted without having to save and refresh the report to get the sort order to take effect.

I'm pretty sure Dynamic View or WorkApps won't be a solution for this but hoping someone has some ideas. Thanks!

Answers

  • Community Champion
    edited 10/24/24

    Workaround to sort Report rows manually?

    Hi,

    I hope you're well and safe!

    You could add a priority column with numbers or letters and sort it by that, change it, update it, and see the change.

    Make sense?

    Would that work/help?

    I hope that helps!

    Be safe, and have a fantastic day!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

    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.

  • ✭✭✭✭✭

    Saving and refreshing is not ideal. That's the only solution I could think of, but figured someone may have been creative in another way.

Trending in Smartsheet Basics