Automating Status of "Completed"


I want to be able to have all tasks with a status of "completed" moved to the bottom of my parent section. I don't want to move to another sheet, but instead to the bottom of the parent. Is there a way to do this? Formula / Automation?

Thanks in advance! -mc


  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭✭

    You could get this functionality if you view your sheet through a Grouping and Summarising report.

    To achieve this you could create a couple of helper columns in the sheet - they can be hidden:

    One called ParentName with the formula of =PARENT([Task Name]@row)

    then another column with a number associated with the order of Status that you want to use. StatusNumber =IF([Status]@row="Not Started",1,IF([Status]@row= "In Progress",2,3))

    Then in the report group by ParentName and it would also sort by ParentName, but you could add a second Sort by StatusNumber in ascending order.

    This would give you what you want, but not directly in the sheet. You can still update % complete and Comments etc from a report.

    Hope this helps...

    Kind regards


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!