Continuously updating a to-do list

[mfoley8518]

I'm working on a spreadsheet that's essentially a running to-do list for our department, and is manually updated every day by various team members. I need a formula that will move completed tasks to a separate worksheet, and there are 2 criteria that both need to be met in order for the task to be considered completed. In my case, if the "scheduled" column reads yes, and the "end date" column reads a date that is before the present date, then the task is finished and I want it moved. Additionally (and here's the kicker) I can't use macros because the spreadsheet needs to be accessible on the online platform, which apparently doesn't support macros. Can anyone help? Happy to provide more info to anyone who thinks they might know a way around this. I've included a screenshot for reference.Thanks so much!

Maggie




View attachment 93227

 

[mfoley8518]

I'm working on a spreadsheet that's essentially a running to-do list for our department, and is manually updated every day by various team members. I need a formula that will move completed tasks to a separate worksheet, and there are 2 criteria that both need to be met in order for the task to be considered completed. In my case, if the "scheduled" column reads yes, and the "end date" column reads a date that is before the present date, then the task is finished and I want it moved. Additionally (and here's the kicker) I can't use macros because the spreadsheet needs to be accessible on the online platform, which apparently doesn't support macros. Can anyone help? Happy to provide more info to anyone who thinks they might know a way around this. I've included a screenshot for reference.Thanks so much!

Maggie




View attachment 93227

screenshot for refernce