The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [column]

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

317 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
2answers
679 views

Making a yes/no column show an icon rather than text

I'd like to have a Yes/No column that rather than showing the usual text ("Yes"/"No"), shows an icon - say green or red. I know I can create another column (a calculated one) with a formula that ...
0
votes
1answer
183 views

Calculated Column Formula Field Count Numbers of days unles status = X

We want to create a list of contracts currently underway. We have created a column with a calculated formula: Time in progress =TEXT(NOW(),"dd/mm/yyyy")-Created what we need to add to this formula ...
0
votes
1answer
517 views

Sharepoint Online - Recover column from lists of project sites

I have a site collection with a lot of subsites attached to projects (each subsite is a site created by a project). Those subsites has a list with its fields. I executed a PowerShell script that ...
0
votes
1answer
18 views

If-$/true=$ - assistance needed with field formula

I am tracking a list on sharepoint and want to use this to reconcile the invoice. I have a field named "Appraisal Type" that has two choices. If one of them is chosen (MVProRE Exterior)I want ...
0
votes
1answer
29 views

Any way for me get the nice 'as you type' autocomplete suggestions in my People and Groups fields?

Using SharePoint 2016 On Premises, vanilla set up and I’m a noob. In various places where SharePoint shows People & Groups entry, it offers a nice PeoplePicker interface where as you type a name, ...
0
votes
1answer
96 views

On exporting SharePoint 2010 to Excel File Unable to export the Date Modified Column

On Exporting SharePoint Document Library to excel file able to export all the columns except the Modified date column
0
votes
3answers
398 views

CSS: Hide empty column on SharePoint List

How do you delete or make hidden this additional column that sticks out from the header row? Can this be done using the HTML or Content editor? See attachments below. Content Editor: <style ...
0
votes
1answer
61 views

Adding column to a document library automatically in SharePoint 2013

For a document library in SharePoint 2013, there will be 3 columns by default i.e., Name, Modified and Modified by. But I want an extra new column with a hyperlink to be added along with these 3 ...
0
votes
1answer
35 views

How to update value into extra column in calendar app

I use calendar app to create a form for Training Course Registration. Location, Start & End time, Description are default column in calendar and I added new extra column (MaxOccupy and AttendCount)...
0
votes
1answer
456 views

Group by more than 2 columns in SharePoint 2013 in Data view Webpart

http://www.dotnetsharepoint.com/2015/05/group-by-more-than-2-columns-sharepoint.html this link which was mentioned earlier didnt worked out for me though i followed each and every step properly. Can ...
0
votes
1answer
310 views

Get child item count to only show on folders, not on documents too

Part 1: For the main all documents view, I have only folders which show the item child count. That is how I want it, but then, when I click into the folder which only has documents in it, I would like ...
0
votes
2answers
935 views

Create Custom People Picker Column in SharePoint 2013

I want to create custom Person or Group type of field which is mapped to User profile.when we add user name to that field then auto fill other columns like first Name,Last Name,Email,Work phone. In ...
0
votes
1answer
461 views

Calculate Columns to create Leaderboard

I have created an InfoPath form for a company-wide Step Competition that will have different communities competing against each other for walking the most amount of cumulative steps. Each form ...
0
votes
1answer
16 views

Is it possible to set up a list Title so that when clicked, the URL associated with the Title is launched?

I have a Content Editor Web Part that shows a Title (of an article) and the associated URL next to it. Users click on the title and the Edit box opens. They should click on the URL, but they don't. ...
0
votes
1answer
23 views

Default Column in SharePoint List

I am not sure what it is called, but I want to change the Key column so that the Open Menu is on a different column. The column it is in now is going to be a hidden column.
0
votes
1answer
453 views

Task list Due Date column

I have many problems in using a 2013 Reusable Workflow. I have to copy tasks from many task lists in the site to a single general list: in order to do it, I have created a Reusable Workflow and ...
0
votes
2answers
2k views

Save to a People or Group column using SP 2013 REST API by login name only (without the ID)

This question will be a duplicate of this one (which has no accepted answer). I am trying to save a SP 2013 list item using the REST API. One of the columns is a People or Group column. Normally ...
0
votes
1answer
77 views

Trying to create a lookup field but unable to find the source field

I created 2 lists (A and B). A Field1 field2 Field3 B Field4 Field5 Field6 On A I have a lookup field Field2 which is based on the Field4 of B. It works fine. I would like to make a lookup in ...
0
votes
1answer
964 views

List that I've created is defaulted with “Stop editing this list”, want to make it so it defaults as “new item or edit this list”

One of the lists I've created is defaulted with this interface: I want it to be able to default with "new item or edit this list" instead as such:
0
votes
2answers
76 views

Need to grab address column and pass it to an array

My script uses an array like this: var locations = [ ['Location 1 Name', 'New York, NY', 'Location 1 URL'], ['Location 2 Name', 'Newark, NJ', 'Location 2 URL'], ['Location 3 Name', '...
0
votes
1answer
38 views

Refinement options… do custom columns have to be managed metadata or can they be attributed to free form text or “choices”?

In order to make it a managed property, does the site column have to be "Managed Metadata" or can it be free form text?
0
votes
1answer
103 views

Counting Field Changes

I need to setup some type of counter on how many times a field has been changed in my SharePoint list. Is there any way to do this without coding? If so please explain. Thanks!
0
votes
3answers
196 views

Can I make a column in a library on SharePoint UNsearchable?

Is there a way to make one column in a SharePoint library UNsearchable? Basically I have a list that contains documents, dates and a column for "comments". I want that "comments" column to NOT ...
0
votes
3answers
71 views

List Column autoincrementing Identifier

I want to create sequential ID for transactions under a specific account. So, lets say I have an account XYZ. The first transaction ID should be XYZ-1. The second XYZ-2 and so on. I have a two lists. ...
0
votes
1answer
26 views

Display persons based on view

I have a Person column I'd like to display in some view as just name, some other with presence and again in some other place with picture and details. Does anybody know a workaround to get it (unless ...
0
votes
1answer
35 views

How do I multi-entry Column Default Values in SharePoint 2013 Document Library?

There are 12 monthly folders, one for each month. I want to set default values in each for automation operations. Current method I am using: Go into the Library Setting Click in Column Default Value ...
0
votes
0answers
134 views

get computed field source field in CSOM/JSOM

I know how to get all the fields in a list using CSOM/JSOM. What I cannot figure out is how to get the source field for computed fields. For example, the LinkTitle field is a computed field soured ...
0
votes
1answer
1k views

Infopath 2013 validation error message about a missing field

Currently testing a Sharepoint list form customized in Infopath. Once I've been through the whole - long- form in Sharepoint, and click on 'submit' the form returns a message error that reads: ...
0
votes
1answer
44 views

Using actual Dates to calculate a list column

We are on SharePoint 2013 externally and Office 365. I am trying to make a calculated column to filter a list on specific dates but it keeps error. Is it possible to calculate on dates such as Between ...
0
votes
1answer
49 views

Unable to save data in picture library SharePoint 2013

I have created picture library using default template in SharePoint 2013 site. I have created new columns for picture library. In above image, I trying to save new value for Country column. when I ...
0
votes
2answers
42 views

Does a field need to be placed within an InfoPath form in order to store a value?

I'm interested in storing a boolean value in a field. However, I don't necessarily want to place the field onto the form. Can values be stored, changed and used in rules without inserting the field ...
0
votes
1answer
99 views

Export a list column with name “Workflow”

Has anyone ever seen this strange behaviour or can confirm? I have a custom list (in a SP2013 site), very simple and clean structure, only Title field and one additional custom list column named "...
0
votes
1answer
26 views

Create calculated field with colour shading

Have a document library with Expiry Date column for specific documentation. I need to set up a calculated field to highlight documents that expire within 3 weeks / 2 weeks and 1 week from the date ...
0
votes
1answer
316 views

Update user field based on the selected lookup value

I need to update a user field based on the value selected from a lookup column. Ex: I have a lookup column with Location details. When I select a location the corresponding manager name gets ...
0
votes
0answers
76 views

SharePoint List with large number of columns goes off the screen in Oslo Theme

My SharePoint site uses Oslo theme. I have a SharePoint List with large number of columns. Whenever this List is opened, there is alot of blank space on the left side of the page. Here's screenshot-...
0
votes
1answer
649 views

Spservices autocomplete with many columns

Could somebody advise how can I make autocomplete for multiple columns, currently I'm using it for one column: $().SPServices.SPAutocomplete({ sourceList: "My list", sourceColumn: "Email", ...
0
votes
2answers
373 views

Job title column

Is there a way I can capture the users job title at the time they add an item to a list. I'm able to show the users job title in a column however it will change when their job title changes. I would ...
0
votes
1answer
77 views

Discussion Board data missing in column

On a SharePoint 2013 intranet, I created a discussion with "Created By" being one of the column. The column is to show the Office, users are from. The office is displayed for some users while being ...
0
votes
2answers
37 views

Help with calculated columns

I have two columns in my SharePoint list called name and email, So I want to have the name be the display name and have the value of the email. So when a users selects a name he or she won't see ...
0
votes
1answer
76 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 ...
0
votes
3answers
107 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
515 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
1answer
322 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
1answer
211 views

Get schema name of specific field in list

How to get Schema name of specific field in a SharePoint list? I'm using SPservices to get list items from the list but one field is missing in the result. I want all field values of the list
0
votes
1answer
73 views

List Column visibility

I have a list where users can create a new item. There is a column named "status" that should not be visible to users when adding a new item. That column should be visible when editing an item and ...
0
votes
1answer
282 views

Column validation based on another column

I have a list where users can fill a column named "External effort (m/d)" (type of column is number). After that column, I have "External resource cost" column, which type is currency, and where users ...
0
votes
1answer
741 views

Efficient way to get all the field (column) values in an array from SharePoint List

I have to get all the field (column) values in an array from a SharePoint list. Right now I am looping through all the items in the list and creating an array. But it is very inefficient if I have ...
0
votes
1answer
58 views

Unable to send emails to address stored as a String

I am having trouble with a helpdesk we are using. It had been set for internal staff to use and so when they raised a ticket, it remembered who they were and could then send email updates out nice ...
0
votes
0answers
96 views

Color code Columns?

we have imported a spreadsheet into a new list on a SharePoint 2013 site and as a result have a lot of data with many columns. What we want to do is colour code it as per the original spreadsheet - ...
0
votes
1answer
220 views

How to get SPField and avoid exception that it is not exists?

I run now this code and got an exception on the first row. How to avoid an exception when the column doesnt exists? SPField field = contentType.Fields.GetFieldByInternalName("ArticleStartDate2"); if(...