Tag Info

New answers tagged

0

What is your [ME] formatting? On my Office365 environment it is: i:0#.f|membership|username@domain.com I have to Creat my own Column ME in the List/Library Creat a Calculated Column with Formula: =RIGHT([ME], LEN([ME])-FIND("membership|", [ME])-10) Delete the Column ME And before I can make a change to the Formula I have to recreate my own ME ...


1

To remove domain part, you can try the following formula =RIGHT([Me], LEN([Me]) - FIND("\", [Me]))


0

Add a number Column 'Completion changed' (don't need a Calculated Column) Add a text column 'previous Completion Date' Create a SharePoint Designer Workflow Set to trigger on Item changes Workflow steps: read value from previous Completion Date read value from Completion Date if values are equal then do nothing if values not equal then read value from ...


1

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


0

Try creating a view with filter where due date is less than [Today] - 5


0

Besides SUBSTITE not being available as a SharePoint Calculated Column Formula you have another problem.. If Speciality is a Choice-CheckBox Field it is not available for use in a Calculated Column I presume that is why you state "I have a workflow setup to export that data" and assume your Speciality column is a Text column filled with the choices by the ...


-2

Source Using calculated field to retrieve substring of another field Suppose for example you have a field that contain the following data as in the above link : ========================== | Email Address | ========================== | Jack@wonderland.com | | Peter@nobodyland.com | | Jill@wonderland.com | ========================== And if ...


0

In 2013 its best to apply CSR with a JSLink, but this method has some drawbacks like having to set the JSLink for every View, and not being able to (easily) have multiple Views on one page. In SP2010 I used these steps to Sum a Calculated Column (which can not be done with a View Total) It uses Javascript in a Calculated Column to do the math while the ...


0

Well one solution would be to have a Total field on the form the user has to manually input, breaking and parsing that is going to be difficult with any ootb tools. A slightly more sophisticated method would be to use javascript or jQuery to break it apart as it is in a somewhat predictable parrern. Even this can be fragile if people don't adhere to the ...


1

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" ...


0

You can use the MAX function to get the highest from 3 values Append leading 000 to the result (padding left you mean, I presume) Then use the RIGHT function to get the last 3 digits Available Functions and Syntax List is at ViewMaster365.com/functions Off the top of my head (so likely wrong, as it is 08:00 here in Amsterdam and I haven't finished my ...


3

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 ...



Top 50 recent answers are included