Moving Rows with a Formula

Moving Rows with a Formula


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 McKayChris 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.

Sign In or Register to comment.