New answers tagged

0

You can use a calculated column and use a formula like this =CONCATENATE("<a href='mailto:",[email],"'>",[Name],"</a>")


0

I think so. Best approach is to read (all) SharePoint Formula Functions (there are not that many), read the Description & examples and see what matches your need http://viewmaster365.com/365coach/#/Calculated_Column_Functions_List


0

Go to Library Settings. Go to Advanced Settings. Click "Yes" radio button for the field "Allow management of content types" Click OK button. This should bring you back to the Library Settings page. What is different is Content Types section displaying. Under Content Types, click Document. Scroll down to click Title under Columns. Under Column Settings, ...


0

I believe this can be achieved by providing the site column's schema when creating a field in the target list. First, the desired site column's SchemaXml property is retrieved using one of the fields endpoints: https://[site url]/_api/web/fields('[field guid]')/SchemaXml https://[site url]/_api/web/fields/GetByTitle('[field title'])/SchemaXml This can ...


0

If you don't already have a lot of data in the list, I would make it 6 columns total Team Name Month work demand planned work demand Actual overtime demand planned overtime demand Actual You will have to enter an item for each month for each team but it will make pivoting with that data much easier when you export it into excel.


1

I don't think there is something OOB for multiple columns. I would suggest to use JavaScript and override PreSaveAction to prevent the save if the combination exists. Something like that : function PreSaveAction(){ //get field 1 value //get field 2 value //perform a query to check if there are items that matches criteria if(noresults) { ...


0

If list doesn't contain any dynamic column one can use below script to achieve freezing header with vertical and horizontal scrolling. Note: Tested with SharePoint 2010 only //jquery lib <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.2/jquery.min.js"></script> //style sheet <style type="text/css"> .fixedBlock { ...


3

Go to List settings -> under Content Types heading all the content types the list is using are listed Click any content type, this will list all the columns and click the column you will be able to delete the column by using Remove button at the bottom (don't worry it will not delete from the parent content type - it will just delete the column from list ...


0

Take a peek at how Microsoft does it; there is a new App in the Store https://store.office.com/office-365-project-portfolio-dashboard-WA104380116.aspx?assetid=WA104380116&ui=en-US&rs=en-US&ad=US I have not seen this app... so I am not saying it has any value!!


0

Assuming that each contact can only be assigned to one project, then one possiblity could be to use different content types based on the project the contact is assigned to. Have a base Contact content type. Then for each project create a Project X contact content type, which inherits from the base Contact content type and adds the fields needed for Project ...


0

Why not have a list of all contacts and then have a lookup column that pertains to the project or projects he/she is on? Then you can filter in or out the contacts that the Project pertains to. The contact would have a lookup column called "Project" that would point back to the Project on hand--and let there be multiple selections.


2

no its not possible ootb in 2010, your talking about changing the identifier column. its easy todo but would require coding tho! it will get messy quickly! say you have 1 , 2 , 3 , 4 and you removed 2 so you now have 1 , 3 , 4 . you would need to not only change 3 to 2 but anything after it down a notch! you can do this in code using the item deleting ...


1

Re-indexing the ID in List/Library is introduced in SharePoint 2013. There is no OOB solution available in SharePoint 2010 to re-index the ID column. You can index SharePoint 2010 columns with the help of topic mentioned in below link. SharePoint 2010–Indexing columns in a SharePoint List


0

You can write up a simple workflow on Item Creation and Item Updation to set the Name field to be equal to Title. Example in SP Designer Workflow: Set Current Item:Name to Current Item:Title


1

Turn management of content types back on. You will have a list of columns that includes "Used in." So if Column B is used in Content Type B only, it can be deleted.


1

Note that all fields properties that have a return type of boolean, are set binarily (i.e. 1 = true, 0 = false). I would recommend looking at the return types of each of the properties you are trying to set on MSDN, SP Field Properties. It looks to me as though all your Boolean values are being incorrectly set. Set thusly; <Field ...


2

You could use greater than lesser than condition IF(AND([Weeks Left]>=1,[Weeks Left]<=12),"coming soon",IF(AND([Weeks Left]>=13,[Weeks Left]<=26),"Plenty time left","None"))


0

If you don't want to use version history, this approach will work for a list: customize the list form with InfoPath. Add a multi line plain text field for the change log. create an XML file that has a node for each field you want to monitor add the XML file as a data connection Use Form Open rules to write the current values of the monitored fields to ...


0

Easiest way is version history. It shows who modified which columns and when.


0

You can not do this out of the box. Development is required (or workflow like Jammin said) An alternative is to create an event receiver. This event will run whenever an item is updated. At that time, through code in C#, you can verify which columns were modified and by which user. And you can create new columns to register the author of such changes. ...


0

Possible through custom SharePoint Designer workflow and lots of hidden fields. Assume 10 columns of visible info Column1 has data, column11 has what data used to be, column21 had column editor On item change check if column1 = column11 if not, set current user in column21 Then set column11 = column1 You will need steps 1&2 for each column you want ...


4

No. You'd have to use an attachment as a List item, otherwise you'd have to set up an asset library and use that asset attachment in a hyperlink column. Alternatively, you could do some development that would customize a form that users can fill out that would upload a video to an asset library and also post it to a List item using the new hyperlink of the ...


0

By adding one more Choose inside the DIV =IF( ISERR(RIGHT(LEFT(Level,2),1)-1) ,"" ,"<DIV style='font-weight:bold; font-size:24px; color:" &CHOOSE( RIGHT(LEFT(Level,2),1) ,"blue ","green","yellow","orange","red") &";'>• " &CHOOSE( RIGHT(LEFT(Level,2),1) ...


0

I solved this using the link here: SharePoint Stoplights to achieve the same thing, you can then use filters to search for 1,2,3 etc. It uses custom XSL link instead of the javascript injection which for our environment at least causes less issues. Also check out This question/answer if you plan to use group by on your view.



Top 50 recent answers are included