Moving Rows with a Formula

edited 12/09/19 in Formulas and Functions


I have several Tasks. I want a formula that moves the whole row of a task, upon it's completion, to the bottom of the task list. 


Thank you for your help,



  • Chris McKay
    Chris McKay ✭✭✭✭✭✭

    Hi Sohlbe,

    Smartsheet lacks the functionality to sort rows automatically within sheets and filters do not allow you to sort either, so there is not really any way of doing this I'm afraid.

    Even with Excel, you'd really need to write something in VBA to achieve this in the manner described.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!