Hot answers tagged calculated-column
You are asking for a No SharePoint Designer and SharePoint 2010 solution. It can be done in a Calculated Column without the use of any other Webparts like documented on the blogs the other answers refer to. The technique is documented at http://www.viewmaster365.com/#/How The cons of this approach are also documented. But it ain't easy; Calculated ...
You don't need a calculated column for this. Just use your existing [DueDate] column twice in your view filter: Show the items when column DueDate is greater than or equal to [Today] and when column DueDate is less than or equal to [Today]+5
Try this out Step 1 : Sort the numbers (Formula below). To keep the formula concise I had to user "123","321"etc. They represent the order of values. So, "123" means order in ascending i.e. value1 value2 and then value3 IF( Value1<Value2 , IF( Value1<Value3 , IF( Value2<Value3 ,"123" ...
Only top voted, non community-wiki answers of a minimum length are eligible