Can you move entire rows based on colour?


For example, I have a sheet that contains multiple tasks. Once the task is completed the row containing the tasks information will change to green.

I would like to then move all green rows into another sheet to produce a sheet of completed tasks. As tasks are added and completed each day, I am looking for this to be an automated system. Consistently pulling any completed tasks from the main sheet into the completed task sheet.

Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer ✓

    Hi @Jonathan Valente

    Hope you are fine, it's easier to design your workflow to move the row using the status column as following:

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!