Autopopulate tasks that have not been completed for next day objective

Kaikai

I would like to know how tasks assigned to a person, but have not been completed and thus assigned a "red" status may autopopulate to a new field/cell for the following day so that I would no longer need to copy and paste the same task.

Andrée Starå

Hi @Kaikai

I hope you're well and safe!

One possible solution could be to copy the rows to another sheet and then, using cross-sheet formulas, collect it back to the next date or something like that.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!