Questions tagged [column]

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

Filter by
Sorted by
Tagged with
3
votes
1answer
119 views

Document Library Required Columns

I'm trying to organize a document library by using different columns of information. I have two columns that are drop-down menus and one column that is a single line of text, all of which I set to be ...
3
votes
0answers
926 views

How can I create a traffic light status column

I want to create a traffic light status column in my task list. I have referenced the Path to SharePoint solution (and most of the others out there) but using a calculated column to display HTML and ...
3
votes
3answers
222 views

Create a Field that only accepts SharePoint groups

I need to create a SharePoint 2013 field that only accepts groups (from SP, not AD). I know I can add UserSelectionMode="PeopleOnly" to make it accept only people, but I want the opposite. Is there ...
3
votes
1answer
2k views

Phone number column validation

I want to add phone number column with below format: 1-121-343-6917, 434-5503 & 60-12-444 444 Used below method =TEXT(123456 ,CHOOSE( LEN(123456) ,"0" ...
3
votes
1answer
638 views

Add Rich text column to the Blog Post comment (SharePoint 2013)

I am trying to customize the Blog post comments in SharePoint 2013 by adding a new custom column using RichText (called RTBody) and hiding the old one called Body in several pages, such as Post.aspx ...
3
votes
1answer
132 views

Set value of “column b” with “column a”

I would venture to guess the answer to this is no but I am going to ask anyway... Is there any way, without an event handler, to set "column b" equal to "column a" without changing the default value ...
3
votes
0answers
152 views

How do you validate a column only if it's new item being added? [duplicate]

I recently added validation to a field which works great. =[Arrival Date]>=TODAY()-5 However, I ran into an issue when an employee is editing an older item to update the "Status" but it's not ...
3
votes
1answer
517 views

SharePoint API for Programmatically creating Fields, ContentTypes etc

I am looking for a SharePoint API which can be used to programmatically create Artifacts like Fields, Lists, ContentTypes etc. using SP 2010 Object Model. The objectives are: Provide simple way of ...
2
votes
3answers
18k 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 ...
2
votes
1answer
2k views

Differences between a fields DisplayName and Title

What are the main differences between a fields DisplayName and a fields Title? Why are they sometimes different and sometimes the same? What is the best practice regarding naming the DisplayName and ...
2
votes
1answer
464 views

Is there a way to create a large number of columns quickly?

I am about to create 84 choice fields for a timesheet solution I am creating in Sharepoint. Clearly I am procrastinating on this task and here I am. Is there a trick I don't know about that might ...
2
votes
2answers
77 views

How to set Date Time Column

I have a column in my List that is of type Date Time. By default I want it to display the Date as Created + 14 days. I tried the below in the column settings: HOWEVER, when I click OK I get the ...
2
votes
2answers
776 views

Can't get calculated column syntax right

This "ought" to be easy and yet as with so many things SharePoint, it isn't. I have a calculated column where I keep getting a syntax error. If the user sets a dropdown column value to x, then y ...
2
votes
2answers
5k views

Calculating Fiscal Year

I am creating a document library in SharePoint 2013, where I want to have a column which shows the fiscal year (= not the date, only the year). It has to be a choice menu, since people in the ...
2
votes
1answer
6k views

How do I unhide hidden column in SharePoint 2010?

I've upgraded a SP2007 to a SP2010 and now some settings have been lost. In some CQWP I need the Created column to group items etc. How do I unhide it so it is selectable in dropdownlists and displays ...
2
votes
6answers
5k views

How can I auto-increment a column?

I am working on a solution where I have a list with a column named LogIDNumber. For each new entry in the list, I would like to increment the LogIDNumber by one. I could use the ID generated by ...
2
votes
1answer
13k views

Sharepoint 2013: changing column order is not refleted in the list

I changed the column order on a list item. These changes are reflected in the "column ordering" view. However, the changes are NOT reflected in the actual list layout. I tried emptying the browser ...
2
votes
3answers
15k views

Current user in field

Can I set the default user in a user field to the current user -> [Me]? How is it done? The xml I already have is: <Field ID="{F117832D-E722-460C-A083-162C55B701F9}" Type="User" Name="...
2
votes
1answer
485 views

Weird behaviour when renaming “Title” column in german site collection

Today I experienced a some what weird behaviour when renaming the default "Title" column of a custom list. Note that im on a german site collection with english as selected menu language. The ...
2
votes
1answer
5k views

Number type List Column returns double values instead of integer

I've created custom list via browser, and set one of it's column's type to Number. I've set number of decimals to 0, so I was expecting, that numbers this column will store would be of type integer. ...
2
votes
1answer
19k views

Change Field's DisplayName in a List

I'm trying to change the DisplayName for a field that belongs to a list. Below is the code that I'm using. using (SPSite site = new SPSite("http://sp10dev/sites/demo")) { using (SPWeb web = site....
2
votes
1answer
8k views

How can I remove Category from the SharePoint 2010 blog posting form?

How can I remove Category from the SharePoint 2010 blog posting form? Apparently Category is a protected field cause I can't delete it, which I don't want to anyway. I just don't want Category to be ...
2
votes
2answers
500 views

Column Level Security Products

I am looking for recommendations on products that handle column level security. What is the best product out there? Any input will be greatly appreciated. Thanks!
2
votes
2answers
4k views

How do you create a multi-select people-picker field programatically in SP 2007?

I would like to create a people-picker user field where more than one user can be chosen. Currently, this is what I'm doing: SPField field = new SPField(contentType.Fields, "User", "Users"); ...
2
votes
3answers
1k views

Sharepoint2010 Lists Lookup

I'm creating 3 lists using Sharepoint 2010 UI. The lists and relationship are as follows: Training (parent) -> Training Instance (child, look up Training ) -> Training Session (grandchild,lookup ...
2
votes
1answer
3k views

SharePoint Online: List column filter not showing all values present in it

A simple SharePoint custom list in office 365 has 8 columns and no special settings are enabled on it. The columns are of type choice and has 5-6 types of values present in them. The OOTB column ...
2
votes
1answer
85 views

Is there a way to remove the time displayed in the scheduling end date column?

We've created a view of expired pages showing last reviewed date and scheduling end date. Our last reviewed date can be formatted to just show the date, but can't seem to do this with the scheduling ...
2
votes
2answers
4k views

How to modify/add columns to a default list view using JavaScript

Using a JavaScript, I create new custom lists including some new fields. After list creation, the default view shows all the added fields. But I also want the columns 'Modified', 'Editor' and '...
2
votes
1answer
56 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 ...
2
votes
1answer
2k views

Replace comma delimiter in a multi-select choice column

A SharePoint list has a multi-select choice field. When 2 or more values are selected for an item,it is displayed(in the view)as: Value1,Value2,Value3,Value4,Value5,Value6 Is there a way that I can ...
2
votes
1answer
1k views

Can anyone color code a column with an if statement?

Here is what I am trying to do. I have a SharePoint 2010 list that I want to color code dates based on that it expires 364 days after the date entered. Example: If the date is older then 334 ...
2
votes
1answer
6k views

How to use the Content Search Web Part to filter on a custom column property?

I am quite new to SharePoint 2013 and I have been working lately with the Content Search Web Part. However I haven't been able to make possible a filtering through a custom column that I have on a ...
2
votes
3answers
15k views

Missing fields in the NewItem, EditItem, ViewItem forms

I am using sharepoint 2010. I have a document library. This document library has no content types. It has directly 5 columns. When I go to this document library I see the allItems view and shows all ...
2
votes
1answer
2k views

Assign multiple term sets to a single column

Is it possible to assign multiple term sets to a single column in 2010?
2
votes
2answers
4k views

Sort “Assigned To” field containing multiple values

Have assigned default column "Assigned To" for new list "Issue Tracking" with following settings: Require that this column contains information: No Allow multiple selections: Yes Allow selection of: ...
2
votes
1answer
637 views

Can't find a site column that DOES apparently exist

Well I've deployed a site column from my xml definition and upto now it's been fine. I then checked my content type (after some unexpected errors) and it's removed itself from the content type and is ...
2
votes
1answer
2k views

GetListItems - viewFields null vs. empty XmlNode

I noticed that for a particular list, calling GetListItems and passing null for the viewFields argument, I wasn't getting back all of the columns. Just a few were missing. After some trial and error,...
2
votes
3answers
6k views

Making field required due to selection of previous field

Is it possible to make a field required due to the selection of a previous field? So, if I have a dropdown with options (a, b, c, d) and if the user selects "d" then notes are required, but if they ...
2
votes
1answer
84 views

Update SharePoint Online item build-in fields via Microsoft Flow

Is it possible to update SharePoint Online build-in fields (like "Created by") by using Microsoft Flow? When creating a new flow and using step "Update file properties", I can only select values to ...
2
votes
2answers
26 views

SharePoint IF calculation needed to consolidate columns

Looking to solve this issue IF Brand = A, B, C or D, then 'Special Brand'; otherwise (Brand = E and) if Buying Status = 1 or 2, then 'Top Tier'; Otherwise 'Bottom Tier'
2
votes
1answer
24 views

Person or group column type won't allow manually typing name

I have a document that was created by someone that left the company so his name no longer appears in the pick list. (I assume this is fed from Active Directory). Is there a way to enter a name that ...
2
votes
1answer
392 views

Is there a way to view version history of a column attribute changes?

This question is not about version history of changes made in an item record but changes made to the columns or attributes within the list settings. Like for example when someone adds a new attribute ...
2
votes
1answer
2k views

How To Add Color To SharePoint List Column Background?

I have a requirement to make the background of a column in a SharePoint list colored (e.g. green). I have seen posts on CSR, JSLink, Conditional Formatting, etc. & all of these articles target ...
2
votes
2answers
1k views

Is it possible to set permission at the column level in a list?

I built a list that include several columns and I'm trying to restrict editing permissions of certain users to only one column within the list. I've been able to set permissions only to the entire ...
2
votes
1answer
24 views

Delete a column from one view but not another

i want to delete a column in my document library from some of my views but not all of them. How is this done?
2
votes
1answer
564 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
49 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",...
2
votes
1answer
3k 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 ...
2
votes
1answer
2k views

Cannot edit column type or delete it in Sharepoint 2013

I have imported an excel file into SharePoint 2013. One of the columns I imported was PolicyType. It is currently set as a text field but I need to change it to a choice from a menu field. I don't ...
2
votes
5answers
8k views

Calculated column that updates daily

Is there a way to make a column in a list that updates daily with the current date? If not what's the best way to do this? I was thinking of using the 'Lookup' field to link to the calendar that's on ...