Moving Rows with a Formula

Sohlbe

Hello,

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,

Sohlbe

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.