Is there anyone out there with a lot of knowledge around calendars?
We have a regular schedule of tasks that are performed counting back from a "deadline date" (excluding weekends).
I currently have a formula in there but have to manually account for the weekends and a HLOOKUP driven off a dropdown list to drive the different views.
What I am trying achieve is:
1) An entry form that asks for the "deadline date" which will populate the task list
2) And view selection criteria different views ie: All tasks, Important dates, Financial Officer View, Accounting View, Finance View, etc (using Toggles, checkboxes?) that will populate a "Calendar" View based on selected criteria.
Note: sometimes multiple tasks occur on the same day.
Any ideas on automating this in some way would be very much appreciated.
Thanks.
Linesy
We have a regular schedule of tasks that are performed counting back from a "deadline date" (excluding weekends).
I currently have a formula in there but have to manually account for the weekends and a HLOOKUP driven off a dropdown list to drive the different views.
What I am trying achieve is:
1) An entry form that asks for the "deadline date" which will populate the task list
2) And view selection criteria different views ie: All tasks, Important dates, Financial Officer View, Accounting View, Finance View, etc (using Toggles, checkboxes?) that will populate a "Calendar" View based on selected criteria.
Note: sometimes multiple tasks occur on the same day.
Any ideas on automating this in some way would be very much appreciated.
Thanks.
Linesy
