columns (fields) created using out-of-the-box column types

learn more… | top users | synonyms (1)

0
votes
0answers
27 views

lookup with criteria

I have three lists in Sharepoint: Customer Product Lizens A Customer has a unique Name and a Adress. A Product has a unique Name belongs to a specific Customer(can also be unasigned). A Lizens ...
0
votes
1answer
21 views

2010 Branching Choice Columns

I have a dilemma with a list I have that I wish to export to excel and create pivot charts/graphs for... Currently my list has several fields that I wish to consolidate into one. I have: - Team ...
1
vote
1answer
27 views

Unique constraint on multiple columns

I would like to be able to set a unique constraint on two columns to avoid entries like in the 4th record below (1234,B1) ColumnA ColumnB 1234 B1 1212 A1 3211 B1 1234 ...
2
votes
1answer
42 views

Delete column of a list with content type which is not mine

Environment : Sharepoint Foundation 2010 I created a helpdesk list which contains a default content type. When I go to the list settings, I cannot : Delete any field already created at the same ...
0
votes
3answers
33 views

Add columns based on another columns value

I am trying to implement a Basic CRM in SharePoint. Although there are a lot of Add-Ins for SharePoint I want to do it by myself. So I made a sub-site and added some lists for the different modules ...
0
votes
2answers
36 views

Way to keep ID dynamic regarding the number of elements

I am simply asking if there is a way to keep dynamic a field ID auto incrementing in a list: I have 3 elements with ID 1, 2, 3 When Item with ID 2 is removed or moved, I want the element with ID 3 ...
0
votes
1answer
32 views

Force “Name” field in SP13 Library to be equal to '“Title”

As I understand, SP13 searches documents by document Title. When you upload some document to the library, you have to fill in "Name" and "Title" ( the same field twice). What I want to do is to ...
2
votes
1answer
574 views

SharePoint 2013 - Reverse Lookup

I am trying to achieve the following in SharePoint 2013. I have two (2) lists a server list and an application list. Each list contains a lookup column which a user can select which applications are ...
0
votes
1answer
25 views

How do I know which Columns are safe to delete because they are used by a removed content type?

This list used to have content types (A & B). We have now deleted all list items that were content type B. I have turned off Management of content types. Columns for content type B still appear in ...
0
votes
1answer
55 views

Allow multiple selections on Person or Group field

In SharePoint 2013 on-premise I am trying to create a Person or Group field to use it in a content type. My problem with the field is that I cannot select more than 1 person. I have been googling a ...
2
votes
1answer
32 views

Calculated Columns - IF statement to find all numbers inbetween a selected area

Since my title is unclear let me explain. I'm currently trying to work out if I can use an IF statement to find numbers inbetween a selected amount. Example: =IF([Weeks Left]="1-12","coming soon",...
0
votes
0answers
12 views

Percentage calculated column issue

My code is =IF(OR(Agency="1",[Day Rate ex VAT]*(1-90%)), IF(OR(Agency="2",[Day Rate ex VAT]*(1-90%)), IF(Agency="3",[Day Rate ex VAT]*(1-90.5%)))) This code is basically trying to work out if ...
0
votes
4answers
37 views

How can i make SharePoint Calculated Columns to know who edit some columns data?

How can i make SharePoint Calculated Columns to know who has edited some columns data? I want to know who is editing specific columns, not modified by, and not using version history on each item. ...
0
votes
0answers
16 views

Display a Date in a Column by selecting one of a choice on the other column

I have added a task app for my project lists. There is one column called "Task Status" with three Drop-down choice: Project Assigned, Project in 90% completed and Project Completed. I wanted to ...
1
vote
1answer
43 views

What SharePoint Column is used for a Video?

Is there a built-in column that is used for a video asset?
1
vote
1answer
261 views

Validation formula on new items only

I'm using the following formula to prevent users from entering spaces on the article name field. =ISERROR(FIND(" ",ArticleName)) The problem is the users have already entered data in this field ...
0
votes
2answers
51 views

Adding text to a Sharepoint Traffic Light Calculated Column

I currently have a Calculated column that produces a colored circle depending on another column. =IF( ISERR(RIGHT(LEFT(Level,2),1)-1) ,"" ,"<DIV style='font-weight:bold; ...
0
votes
0answers
10 views

Fields from Infopath form not showing up in site content type columns

So I created a new site content type for a document library in SP 2010 I'm using to store form submissions. I was able to have the content type reference an existing form when creating new items, but ...
0
votes
0answers
30 views

create a view that groups multi choice column values

I apologize in advance if I am breaking rules by asking a question similar to one already asked (SP2013 - Create a view that groups based on individual selections in a multi choice field). I can't ...
0
votes
0answers
26 views

Custom task column on reusable workflow

I had a workflow that was linked to a list. I noticed then that I could make a reusable workflow, which is more practical: I only need to link it to the list that I want, instead of making a new one! ...
0
votes
0answers
22 views

Sharepoint list “Append Changes to Existing Text” + latest Entry

I have a SP list with a column latest updates. This column is set to "Append Changes to Existing Text" with versioning turned on. However, when we go through the list as a team. It's annoying to open ...
3
votes
1answer
63 views

Column validation only when creating new item Sharepoint 2010

So I have a date field that needs to be a future date when the item is created. The formula I have set up for that is: =[Date Required]>TODAY() This works well however I am running into an ...
1
vote
1answer
826 views

Field properties ShowInEditForm not saved

I have a listadded EventReceiver with the following code: public override void ListAdded(SPListEventProperties properties) { SPWeb web = properties.Web; bool safeUpdates = web....
1
vote
1answer
56 views

How to change the font of column name

Is there a way for me to change the font size/ family for a particular column name for Default New Form web part. (jquery/ SPD) Like the following image (diff from default style) Thanks!
1
vote
2answers
7k views

make custom list item column unrequired (non-required)

I have a custom content type with many required columns. The UI does not allow me to change a column from required to non-required (at least, I can't find a way to do it). Is there a way to achieve ...
1
vote
0answers
33 views

Sharepoint 2010 Validation by two fields

I have a SharePoint list with these fields: Destination - User picks a person Created by - User who created the item Is there a way to prevent users from creating item for themselves using ...
0
votes
1answer
140 views

Adding custom column to Workflow Task content type makes workflow stop on assign task

I have been asking a few questions in here lately, as I'm beggining my journey as a Sharepoint Online 'developer' for my new internship. I have a new one for today: I have created a custom approval ...
1
vote
0answers
42 views

SharePoint 2013 - Add Library Column Showing Managed Metadata Level Values

I need to be able to classify all the documents in a library into a Major Category and a Minor Category where the Minor is specific, but not exclusive to the Major. It would appear that the best way ...
1
vote
0answers
28 views

Change a field in SharePoint Online

I have identified a site column with incorrect properties. Specifically I need to change the RichText value from FALSE to TRUE. How can I do that? I have tried to locate Elements.xml and edit that ...
4
votes
1answer
499 views

Field's TitleResource.SetValueForUICulture() does not work for the web's default language

I have a site column in my site collection whose title I change / translate with following PowerShell statement: $w = Get-SPWeb "URL to the site collection" $f = $w.Fields.GetFieldByInternalName("...
1
vote
0answers
18 views

Help with auto calculated field for dates from another column [closed]

I am trying to make a column with expire dates from a date entered in another column. For example I have a column with a date entered for training. I then want another column named expire date that ...
0
votes
3answers
38 views

Calculated Column Question

I currently have a list with the Column - "Level" This column is a choice column with the choices: "Novice" and "Beginner" I'm creating a calculated column called "Score" I want this column to ...
1
vote
2answers
984 views

ID column into the 'link to item' of a list

In a list, how would I make the ID column the column that links to the item's detail screen?
0
votes
0answers
18 views

Create Field which allows choice of values, but value does not change when source does

Using SharePoint 2010, is it possible to create a field which forces the user to select from a dropdown list (based on items in another list), but when the value in the related list changes or is ...
3
votes
1answer
291 views

Convert Field To FieldLookup using ClientContext

I need to get a FieldLookup from a list (already queried). First line in the below code errors out "Unable to cast Field to FieldLookup". Yes, the field I am trying to retrieve is a lookup field only. ...
0
votes
1answer
568 views

How can I make sure that if linebreaks is inserted inside a multiline textbox it gets displayed like it

I have a field that looks like this in my schema: <Field ID="{7662cd2c-f069-4dba-9e35-082cf976e170}" Type="Note" RestrictedMode="TRUE" NumLines="15" Name="Body" DisplayName="$Resources:Project....
0
votes
0answers
5 views

What is the Protocol Name field on the List app, and how do I automate filling it in?

I am attempting to create a Custom List app in SharePoint but am being stymied by the Protocol Name column that is added by the list by default. I don't have a good understanding of what that column ...
1
vote
2answers
40 views

Column validation- User must enter A or B as first character

I am trying to create a validation formula which will verify that the user entered A or B as the first character in the column. Can't seem to get the formula right. Can anyone help? [EDIT] One ...
2
votes
3answers
300 views

Set default value of Article Start Date to [Today] with CSOM

I'm struggeling with setting the default value of ArticleStartDate date-time column using PowerShell and CSOM. Bakground: I have a content type, used by a page layout, inheriting from Article Page ...
3
votes
3answers
4k views

Hide header row for specific list view

Is it possible to hide the header row, displaying column headers, for a specific view on a SharePoint 2010 publishing page? We've used this CSS to hide the column headings, but this is all or nothing; ...
0
votes
2answers
29 views

Setting a field as a hyperlink in a list

I'm attempting to use a calculated column to set the field as a hyperlink. Currently, I'm using this code. ="<a href='"&%URL_Field_Name%&"'> "&[%field_name%]&"</a>" So, ...
8
votes
4answers
3k views

List Validation does not show Error when Conditions are not met

I am using List Validation feature for a list which is working fine i.e. doesn't save the item when condition not met. However, it is not showing the error message which helps to rectify the inputs in ...
1
vote
1answer
42 views

How can I create a [Me] filtered view using a Lookup column with names in it?

Any help will be hugely appreciated as really struggling with this. I am limited by company regulation saying I can't use code so any answer will need to be code free and not require the use of Design ...
0
votes
2answers
34 views

Column Versions

Is there any way of adding a column to show the previous version of an approval status? I want 2 columns: one to show the current version and the second column to show the previous version of the '...
0
votes
1answer
43 views

Lookup column restriction

For a school project we are setting up a SharePoint for a non profit organisation who handle clients. we have made a document library where we store documents sets for every client thats added. In a ...
0
votes
3answers
3k views

Document Library add file with custom column (SharePoint 2010)

I have a document library with a custom column. I want to add a file programatically, as well as a value for the custom column. I am posting the file via an ASP.NET application page. Here is what I ...
2
votes
0answers
27 views

How is the relative list item order calculated from tp_ItemOrder column?

I am using a custom action and the Reorder.aspx page to provide a sorting-functionality to my users. I followed the instructions that can be found here: https://niftit.com/blog/how-to-reorder-a-...
0
votes
0answers
24 views

Sharepoint Column Validation Error - Not going to second page

I added column validation to the drop-down choice questions on page 1 of my survey and it worked fine. The last question of my survey page 2 has branching logic and column validation. When I ...
0
votes
3answers
611 views

Show/Hide columns based on dropdown selection

When adding a document I want to show or hide colums based on a dropdown selection. In this case, the value of "Document type" is leading. If a Travel Document (Column name "Travel Documents") is ...
0
votes
1answer
15 views

list columns, diplaying information provided via lookup from one column differently in another

There is a lookup column within my list that allows the results to be displayed in many different ways. Example: Smith, John W or John.Smith or Employee ID#. Is there a way to add another column to ...