3

You can do this with a validation formula. It can get quite long, depending on the number of holidays, and how far out into the future you want to go. =NOT( OR( [TaskDate]=Date(2019,12,25), [TaskDate]=Date(2020,1,1), [TaskDate]=Date(2020,4,1) ) ) You can also block weekend days in a similar manner: =NOT( OR( WEEKDAY( [...


2

From your description, task item is not deleted in my task when item deleted in SharePoint task list. Per my test, it will sync the task list item to my site tasks list everyone 5 minutes by a timer job. Does your task comes from project site? You can click edit and then delete the task: Reference: https://social.msdn.microsoft.com/Forums/sqlserver/en-...


2

We can add the code below into a script editor web part in task list form page to achieve it. <script src="https://code.jquery.com/jquery-1.12.4.min.js" type="text/javascript"></script> <script type="text/javascript"> function PreSaveAction(){ var dueDate=$("input[title='Due Date']").val(); if(dueDate.trim()==""){ alert("...


2

Change the order of your tests. Start with the "over due" test. You may also want a value if >30 days. =IF(DaysDifference<0,"Overdue", IF(DaysDifference<=7,"7", IF(DaysDifference<=15,"15", IF(DaysDifference<=30,"30", "Over 30") ) ) )


1

To use "Open with Project", you need to have Project Professional installed on your computer for that to work. Two articles for your reference: How to Sync MS Project with SharePoint Sync with a SharePoint tasks list


1

Unfortunatly lookup list items have to be redone when using a template. The template will not hold on to the relationships between the list items. You will hve to delete the lookup values and re-enter them each time you use the template.


1

One option coould be to use Column Validation, however it might be tricky to define a formula for 'holiday' Another option could be to create an event receiver on ItemAdding, there you can check the date against a SPlist that defines the start and end date for holidays ( or similar setup)


1

For your requirements, you can use Timeline webpart in SharePoint 2013. Follow below steps: Add a page(or use existing). Edit your page. Add new timeline webpart from content rollup category. Configure data source to your task list. Reference: Timeline Webpart in SharePoint 2013


1

There are some differences, here is my manual: I tried it with my testing items from classic list. I added User column. User column returns Json of selected users, so you must parse this JSON and do foreach for it. I did it on one item, you will have here One foreach for collection of items and second for the Email attribute for each item. Add: Parse Json ...


1

To use "Today" current date in calculated column instead of using flow/workflow, you can follow the steps below: Create a field named “Today” to make the SharePoint to use [Today] (current date) as part of formula. Create a calculated column with formula =[Due Date]-[Today] to get the number of days between the Due Date and current date. After using [Today]...


1

First create a Calculated Column with below formula and call it By7 [YourDateColumn]/7 Make sure you set 0 decimals. In this case the date range is every seven days. Then in your view, group by column By7 To make this more complete, you could first subtract [YourDateColumn] with a known date so your grouping starts on a specific day, for example monday.


1

Hello use Search Content Query Web-Part and as filter use contentclass:0x0108. It will display all Task lists. You can also create another web part which will display all tasks for user: contentclass:"STS_ListItem_Task" AND "path:"https://company.sharepoint.com/sites/" AND "AssignedTo:"Name Lastname" You'll need to filter Path to for displaying Task Lists ...


Only top voted, non community-wiki answers of a minimum length are eligible