3

I'm not sure what the best work flow is for this but here is my current setup:

  • I have a task list with all tasks for the duration of a project. 
  • I have reports that list all tasks due within the next day or week for the "current user"
  • Currently users get alerts for every task that is due on that day

1

Hi all,

I have a spreadsheet with just 4 columns, and i have a set of rules to apply to them.

One of those rules is sending Update requests if the date column is over 7days in the past.

But, since the spreadsheet will have "countless" rows, i want the rows that had Update requests before, to be

1

I want to set up a notification to begin a task when the predecessors of the task are completed. The tasks in question have two predecessors each and I cannot for the life of me figure out a way to have the completion of those predecessors trigger an alert to the people assigned to the tasks so that

3

I've noticed that some of the dates entered, if too far in the future will revert to last century.

i.e. January 5th, 2050 will work correctly if entered as 01/05/2050 but will think it's January 5th, 1950 if you enter 01/05/50

Also, once you enter the date as 01/05/2050 and it is shortened to