Moving Rows with a Formula

03/26/18 Edited 12/09/19


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.