Questions tagged [column]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
6 views

Sharepoint List - Quick Edit adding a text box

I'm a SharePoint neophyte without admin access. I'm experiencing an odd problem when editing items in a list. I have a column set to 'Multiple lines of text' and Enhanced Rich Text. If I edit an item ...
0
votes
1answer
10 views

SharePoint 2013, Column Ordering doesn't seem to be working

New here. Just started working in SharePoint 2013 to manage various project docs and due dates for my team. I set up a list using the Import Spreadsheet app that had the column headers ordered in a ...
0
votes
1answer
18 views

SPO How to set permission for a specific column in a list?

I have a list contain 3 columns: Ex: A,B,C The Admin can create/edit and delete all columns. My requirement is: The invited user can also create/edit and delete except of column C. He can see it ...
0
votes
2answers
934 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 ...
1
vote
1answer
831 views

how to change the format of the “person or group” column

In my document set (Sharepoint 2010) I have a column with type of “person or group” which I can add the name of some users to it. The format of the names is like this: firsName1 Surname1; firstNmae2 ...
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
911 views

How to hide specific column header in a list WebPart?

I created a webpart with URL column header, but i want to hide it for users...i know i can hide it using CSS but it hides all the colum headers in other webparts, Any solution to hide only the URL ...
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", ...
4
votes
3answers
7k views

Field Modified shows date, but no time

In a view of a document library I have the field "Modified" and this is showing only dates but no time. I would like to display the time aswell. From my understanding it is ill advised to alter this ...
0
votes
2answers
33 views

In a library, I find a column called TAGS, what is it?

While playing around, I noticed a column appearing among the available ones in the view settings called 'Tags'. I have displayed it and the image inside the library (of a person) showed the tag '...
1
vote
2answers
30 views

Call a flow if a Date column is null

I would like to use a If condition to execute a different flow. Everytime the column "Aprovado Interno" is null calls one flow, else calls the other. However I am having difficulties to apply the ...
0
votes
1answer
19 views

Value of the Yes/No Column

What is the values of the Yes/No Column in SharePoint? 1, 0 Yes, No "Yes", "No" True, False Trying to use calculations: =IF([Col1]=Yes, 1, 0) So if it's true, put 1, else 2. But not matter what, ...
0
votes
1answer
32 views

Show/Hide in New form based on dropdown selection jQuery

I have a dropdown list contain values, last value is called "Others" when its selected i want to show a new textbox under the field and if its not selected it should be hidden. I have followed this ...
0
votes
1answer
33 views

Powershell script to update list column from another column Conditional

Any help is greatly appreciated. Here is the scenario: I have a powershell script which I am using from another post on stackexchange. I have two fields in a list, the script copies the value from ...
0
votes
1answer
30 views

Conditional validation of SharePoint Online column

I am trying to validate a SharePoint online task list column, in the way that the column "Assigned" (People column) must be populated for the user to be allowed to save with info in "Due date" (Date/...
0
votes
2answers
677 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
0answers
6 views

Hide Recurrence Field on Calendar With Several Content Types

I'm having trouble removing the recurrence field from my calendar. I've done it before with a similar PowerShell script as below. It's been modified by selecting the content type instead of the whole ...
0
votes
0answers
16 views

Reset column to default value

Given is a list with a yes/no column. Default value of this column is "no". What is the most efficient way to reset all items in the column to "no". I definitely don't want to solve the problem by ...
0
votes
2answers
16 views

Calculated Column with IF ISBLANK, else if “ABC”, then return “XYX”

If [OH:Subsample ID] is blank, OR if it contains "ABC", then the calculated field should return result "XYZ". No idea how to put that into syntax. I can get two separate lines, but can't get them ...
0
votes
1answer
1k views

On click of save button, 1 column to take the value of another column in a list

I have a list with columns "due date" and "revised date" in SharePoint. I want to enter the due date column only when I am entering items for the first time. Onclick of save button I want the ...
0
votes
1answer
13 views

Delete column from content type doesn't work

This is the code I use: Add-PSSnapin "Microsoft.SharePoint.PowerShell" $web = Get-SPWeb "Myshareointsite/Projects/Test" $list = $web.Lists["Risks"] $ContentType = $list.ContentTypes["Item"] $...
0
votes
0answers
43 views

Managed metadata columns show numbers instead of terms in document libraries

In Sharepoint Online, when I open a document library that has managed metadata columns, everything looks fine. However, when I preview a document and close the preview, the managed metadata terms are ...
1
vote
1answer
23 views

Is there the capability to store a number range within a column?

I am trying to identify the best column type to store a selection of number values and ranges of number, e.g. 10,000-20,000. A majority of the values will be individual numbers but some need to ...
0
votes
2answers
3k views

SharePoint Column Formula Validation

I need to check if a column (type Number) is an Integer (no decimal). I added this formula to the list validation: =mod([MyField],1)=0 But I get this error: The formula contains a syntax error or ...
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: ...
1
vote
1answer
2k views

Conditional Columns in SharePoint List

Is there a way to have a Conditional Column with Multi-Line Text that will only show up in the list if a certain status is selected?
0
votes
1answer
1k 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
2k views

How to Display Created By Field in InfoPath AND Sharepoint list with multiple values?

The article "How to Display Created By Field in InfoPath" seemed to work for a user on this forum. However, my needs are slightly different. I'm trying to create a list with the entry form showing ...
1
vote
4answers
767 views
2
votes
2answers
1k views

Calculated Column needs left alignment

I have the same exact problem as related here Calculated Column left align header However, the solution suggested is inadequate. This would require me to manual add the web part to each list that I ...
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" ...
0
votes
1answer
45 views

Referencing 'Version' Column

Hi there, I am relatively new to using SharePoint as well as JSON and as mentioned in the subject, I am having issues in trying to reference the Version column (set by the approval status). What I ...
0
votes
2answers
659 views

Columns not displaying value

I've added some columns (name, ID etc ) to the document library after the documents have been uploaded, and got no value displayed. Is there any way to fix this or I'll have to recreate the library?
0
votes
2answers
3k views

Show only unique (not repeating) values of column in sharepoint list 2013

I have a list with two columns. Column names are Username and Status (options Free and Busy). Usernames can have both Free and Busy status or only one type Free or Busy. To make more clear this is ...
0
votes
0answers
13 views

How to only show specific columns in external list picker

How would one use an external list containing several columns to map each column in the external list to a drop-down control in a SharePoint List item? In the picture attached, how does one take each ...
2
votes
2answers
2k views

SharePoint Excel export issues (ID export to lookup columns/Columns out of order)

Good day, I have 2 issues I am trying to workout on some SharePoint Lists. I was hoping I could get a little help as my developer skills are just now developing beyond OTB solutions. Issue 1: I ...
0
votes
1answer
13 views

Get List Column configuration using pnp.js

I want to fetch the List column configuation to check if a field is required or not. But I am not able to figure out which function to use by looking at the documentation.
0
votes
1answer
54 views

mandatory lookup column doesn't work

So I have a pretty basic scenario. Two lists (Projects and Clients). In the Projects list I have a mandatory lookup field that aims at the Clients Title column. Now when I fill out the form for ...
0
votes
1answer
25 views

How to create a lookup field from another lookup column

I have one lookup column. I need to create another lookup column to look up the existing lookup column in different lists. I am notable to do this, Could you please suggest some idea to implement the ...
2
votes
2answers
2k views

Getting hyperlink URL and description in custom XSLT with Content Query Web part

I'm having trouble getting the URL and description to show as separate items in SharePoint 2013. I'm trying to display the description as the text of the Link and the URL as the HREF value in the a ...
1
vote
1answer
15 views

Adding columns to an existing list on Sharepoint 2010 intranet

I am trying to add two new columns to an existing list on an intranet page (on SharePoint 2010). I've used the guidance here and seem to be able to only get so far. I've found the list I want to add ...
2
votes
1answer
1k views

Amending the Calendar form in Sharepoint 2013

I have a question about the Calendar app. I made the Location field compulsory from the Validation settings and a red warning message appears, when you try to save an event without its location. How ...
0
votes
0answers
18 views

Set dynamic default values for SPO list with custom new form

I have a SP Online list with custom new form. I want to update default values for 3 columns dynamically using the URL and make the columns ready only. For Eg, I have the below URL: https://company....
0
votes
1answer
28 views

How to programatically get the status value of a Content Type column using C#?

I am attempting to read the property of the Item content type which shows the Required, Hidden or Optional property for a particular column. if (spList.TryFindContentType("Item", out SPContentType ...
4
votes
3answers
1k views

Date field validation in SharePoint 2007

I need to limit the Date field in a SharePoint 2007 list so the users can enter date from today and up to year after. How can i do it?
1
vote
2answers
39 views

Hide items in a form

Recently, I see this function broken in SharePoint, I do not set it. Please help me. To begin, Go to List Settings. Click on Advanced Settings. Select Yes on Allow management of content types. ...
0
votes
1answer
620 views

Inadvertently Created Content Type Column and now can't delete it

I created a column on my root site's content type and now cannot delete it. It is somehow locked as "Read Only" and I have tried PowerShell and SharePoint Designer 2010 and every option I could find ...
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 ...
18
votes
4answers
91k views

Can I create some sort of Attachment column in a list?

User needs a list to track issues. They also want to be able to attach a document to this issue. If this attachment was mandatory I would be able to create a document library, but since it is not I ...
1
vote
0answers
7 views

SharePoint default Column values are added to all documents of a library even if the specific contenttype does not includes the column

in our document libraries documents are assigned to different contenttypes. These contenttypes share some columns but not all. If we now define default values for a managed metadata column, all ...