Hello everyone! 

Hoping I can get some assistance from the Gurus around here.

Currently, we have an =IF formula that looks at the Due Date of a project and:

  • if the project is today, it returns THIS WEEK
  • if the project was last week, it returns LAST WEEK
  • if it is next week, it returns NEXT WEEK
  • if it


I have my sheets set up where each row represents a project and respective information.  I have a column in each that can be changed to a department heading and I have an automation set up to make it so that when changed the rows move to the department sheet selected in the drop down box.

Now, I