Hot answers tagged

4

How you can do this: Open your list and open the list settings Select the column "Plan start date" Under Validation setting type in the below formula : [Plan start date]<=[Plan end date] This help you to validate your dates before saving them. Hope this helps !


2

You will need to create custom forms for your requirement. The most popular ways to create custom forms are: SharePoint Designer: Creating a custom form in SharePoint Designer is relatively easy. You take an existing SharePoint list and use Designer to create a new .aspx page which renders and controls the form. There are files used by a list to create ...


2

Even I have the same requirement. But Unfortunately we don't have any option like enforcing unique by combining 2 columns by default. Even I have researched a lot. But we can achieve this by using only info-path form. Hope the below link may help you ...


1

Here is a modified calculation that I have used before and believe it will benefit you as well. =DATEDIF([Start Date],[End Date]-(MOD([Start Date],1)>MOD([End Date],1)),"d")&" days, "&TEXT(MOD([End Date]-[Start Date],1),"hh "" hrs, "" mm "" mins""") For example: If a user enters 8/1/2016 8:00 AM as start date and 8/10/2016 12:30 PM as end date, ...


1

It turns out that the "Created By" field in SharePoint is a lookup column and can display/show a number of different values about the account. If you open the column to edit it, there is a property named "Show Field". In our case, someone had changed this to "Created", which refers to the date the account was created in the user information list. That is why ...



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