Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [column]

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

1
vote
1answer
28 views

Mutiple Choises in Custom Coulmn

I want to create a custom column that has the option to check/mark two or more options. Example Column Name : Sorting_Files: ,Department ,Planning ...
0
votes
2answers
16 views

What will be the rest api query to get field values from site content type using rest api?

How will I fetch choice field values from site content type directly> This is what I have tried: http://<sitecollection>/<site>/_api/web/contenttypes
0
votes
2answers
34 views

Formatting Lost When Creating List Item

I'm trying to create a list item but the most basic formating is being removed from the input. Field type is Multiple lines of text and I've tried using Plain, Rick and Enhanced. Script to create ...
0
votes
1answer
20 views

Updating Site Columns on SharePoint online

We have a document library with thousands of files that are not properly categorized. On of the main reasons this happened is because the columns are not required to contain information. Is it ...
0
votes
0answers
18 views

Cant Delete Field in SP Online List

The event content type was added to my list, I've removed it and disabled content type management on the list. I was able to remove all columns brought in with the event content type, except the "...
1
vote
2answers
46 views

SharePoint 2013 - How do I save the value of a read-only or hidden field?

I'm trying to set a field in a list's edit form with a value after the user clicks "Save." Here's the catch: I don't want the field to be editable by the user (only JavaScript should set its value). ...
0
votes
2answers
43 views

Make a column auto update by Parent Folder Value

I am setting up a new Document Library to organize several different types of Documents. I have a Folder View and a Metadata view. I am using a column named "Section" to sort the metadata view. I ...
0
votes
2answers
30 views

Reset/Remove Default Column Values from folders

I am searching for a better way to reset/remove default column values from specific folders using PowerShell. I realize that it can be done through the library settings but I need to do this for ...
0
votes
1answer
25 views

SharePoint Online Custom List -> Link or Picture Column | Is there a way to upload picture directly from New Item Form?

First of all I am using SharePoint Online with the app "Custom List". In this Custom List I have added a column of the type "link or picture". Basically I use this column for a simple picture view. ...
0
votes
0answers
18 views

Can the hard-coded column name in a custom display form be dynamic instead?

I have a column in a list: “C” is the external column name and “x0043” is the internal column name. For some reason, in a custom display form, the external column name that is displayed is hard-coded ...
0
votes
1answer
19 views

Fields are in different language in view vs in new/edit/display form

I have very strange SharePoint 2010 behaviour. Basically I have SharePoint site in 2 languages, default is English and there is German. So when I change my language to German then there is everything ...
0
votes
0answers
16 views

Custom display form is showing old column names

Situation: I created columns A, B, and C. I created a custom display form with SharePoint Designer 2013 that displays A, B, and C. I renamed columns A, B, and C to X, Y, and Z, respectfully. Problem:...
1
vote
1answer
14 views

How can I create a SharePoint list with a column that can store for ever changing non employee names?

currently we have multiple Sharepoint lists with columns containing drop-downs that contain the names of people that are agency staff so when they complete a form they can choose their name from the ...
0
votes
1answer
40 views

YES/No option no visible in Edit Column

I have this column that I have created and and I wanted to change its type from multiple choice to an Yes/No option. Unfortunately I don't see the option anymore.
0
votes
1answer
31 views

Content type fields marked as “hidden” aren't being hidden in the form?

I have a SharePoint Online list library which allows users to create a list item by using a simple form. In the backend of this site I've configured some hidden columns which are needed for some ...
0
votes
1answer
31 views

How can you edit the format of modern style list/library column headers in Sharepoint Online?

Is there a way to format the column headers of a modern list or library in Sharepoint Online? I would like to make the dividing borders between column headers show up even when you're not hovering ...
0
votes
0answers
8 views

Queried Images to Display in Word Document

I am on SharePoint 2016 and Nintex 2013. Requirement: The team wants a Microsoft Word document that allows spellcheck and other formatting options that are limited or unavailable in InfoPath. I am ...
1
vote
1answer
21 views

Highlight Due Date Column with color

I am using SharePoint 2016. There is a Submittal library that has been created and one of the users would like the "Due Date" column to highlight in yellow when a document that has been submitted is ...
0
votes
2answers
39 views

Date validation to specific year for list Column in view

I've got a date column in a view and I'm using a validation formula: =IF(TEXT([Data documento],"yyyy")="2018",TRUE,FALSE) So that users can only insert date within the year 2018. I always get an ...
0
votes
1answer
38 views

Column Formatting Option not available

I can't see an option for format column where I can enter JSON codes.
1
vote
2answers
138 views

Can we create a look up column from multiple lines of text column in list

we need to create a lookup column from multiple lines of text column in SharePoint online list is it possible.
0
votes
1answer
113 views

Column Formatting using JSON: Get value of the column “_ModerationStatus”

I'm trying to check the value of the column _ModerationStatus in a document library with that has content approval. I have the following JSON: { "$schema": "https://developer.microsoft.com/...
0
votes
0answers
22 views

Character Limit for Approver Comments Column Type in sharepoint.com O365

In sharepoint.com document set library, I am trying to add approver comment when I change the approval status. The comment supports up to 2414 characters, and when I enter more characters, it throws ...
2
votes
1answer
56 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 ...
0
votes
1answer
94 views

How to hide a List View column in Modern SharePoint

I have a List in a SharePoint Online site that uses the Modern experience. I want to hide a column, but need to stay in Modern. The easy way I found was inserting a few lines of Javascript in a Script ...
0
votes
0answers
10 views

Person/Group column displays empty in web part view

New view is created with the person column. I can see the values in the view, when opening view on its own. However, the same view is added as a webpart and the person column is empty. However, when ...
0
votes
1answer
14 views

Column Validation in 2010

I need to use a column to capture ID numbers. I need a way to ensure that the answers entered are only numbers and exactly 12 digits in length. I've tried a zillion different formulas but keep ...
0
votes
0answers
24 views

PWA Project columns

I have setup the columns that I want to see in each new project in PWA. For example: Task mode, Text 1, Task Name, Start, Finish, Duration, Work, etc. When I create a new project in PWA, those are ...
0
votes
0answers
72 views

List people picker graph

I am pulling a list via the graph api. I would like to be able to filter on a people picker field. However I do I use the lookup field id to equate to a user/member i.e the id 18 person joe blogs.
1
vote
3answers
267 views

Retrieving column fields from SharePoing list using sp-pnp-js

I have a list. I want to retrieve the fields to see how many column are there in my list. For example, my list name is TestList, I have created 5 columns of different datatypes. I want to retrieve ...
0
votes
0answers
22 views

Changing the filed type from “checkbox” to “Radio Button” has overridden the “ShowInNewForm” property

We have a sharepoint on-premises farm 2013. I have a choice column which display the choices as check-boxes and it contain one option only, as follow:- but doing so have caused issues when filtering ...
0
votes
1answer
33 views

Sharepoint 2013 - how to make a column content bold in task list

I am struggling with making any content under the 'Task Name' column in bold. I am using Sharepoint 2013. I have a task list (classic) and I want to make each task name in Bold. I would like to add a ...
0
votes
1answer
169 views

SharePoint Online Show/Hide column based on permissions

I have a couple of fields in a list that can only be modified by certain group of people. What is the best way to do this without a 3rd party application?
0
votes
0answers
30 views

column options in sharepoint online list

For a list i created in sharepoint online: On some of my columns, the drop down arrow only shows "column settings" While other columns show "A to Z", "Z to A", "Filter by", "Group by Contact" and "...
1
vote
1answer
35 views

Need advice on proper use of calculated column for my problem

I've been tasked with getting a SharePoint site up and running as part of my job, it requires a semi-automated way of marking files for an archival process where they are taken off of the SharePoint ...
1
vote
2answers
48 views

How can I locate a missing column in my List Settings?

I have a SharePoint Online list that has recently grown to over 5000 items. Here is what a given entry looks like on the AllItems view, with the column I'm interested in circled in red: When I go to ...
0
votes
0answers
15 views

Sharepoint List - How to use various field types in JSON (column formatting) [duplicate]

Some data from other fields can't seem be referenced when using JSON to format Sharepoint List columns. What is being done wrong? For Person fields "@currentField.title" Works "@currentField....
0
votes
0answers
418 views

Use Sharepoint list fields in JSON column formatting

Some data from other fields can't be reference when using JSON to format Sharepoint List columns. What is being done wrong? For Person fields "@currentField.title" Works "@currentField....
4
votes
1answer
61 views

Column Formatting using JSON: Get value of the column “CheckoutUser”

I´m trying to check the value of the column "CheckoutUser" with json. ""style": { "min-height": "35px", "margin-top": "6px", "display": "=if([$CheckoutUser] != null, 'block', 'none')" }" ...
0
votes
2answers
24 views

Is it possible to create a column with two types? [closed]

Is there any possibility in sharepoint to create single column which will have both single line of text and choice as column type? Please suggest if possible.
0
votes
1answer
17 views

SharePoint 2016 - Column Settings missing from column header drop down

I'm using SP 2016 and am trying to access the column settings. I've read you click the dropdown next to the column heading and it should show up... however all I get are the filter options. Do I need ...
0
votes
0answers
21 views

Creating a view where only certain columns expand/collaps

Im busy with a SharePoint site where i need to display member of the team on a page, i want to be able to show all the team members(each of them have an entry in my team members list) but i want some ...
1
vote
0answers
23 views

SharePoint 2013 bulk edit column not updated

When selecting edit list, select the column, the choices are not updated from the lookup list. But if you edit an individual item the lookup choice is available for a selection. How do I get the ...
0
votes
0answers
15 views

Trying to Get Average of a Column in SharePoint - But One Row May Contain Multiple Counts

Ok so getting the average means dividing the sum by the count. Meaning I have a column with a count of 7 rows of numbers that all add up to the sum of 10. So I divide 7/10 to get 70%. Using a ...
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'
0
votes
1answer
36 views

Bulk edit for large number of files not working?

I'm on Sharepoint Online, and I have a document library of about 1600 files. I have about 1000 files that are Unassigned in a certain column that I want to change from Unassigned to some other ...
1
vote
1answer
23 views

Hide columns in spreadsheet/edit view (JS/jQuery/Cisar)

Hiding columns in normal view is ok using either of the functions: function hideColumn() { var header = document.querySelectorAll("[displayname="Column Name"]")[0].parentNode; var index = [].slice....
1
vote
1answer
20 views

Entering N/A into People and Group Column

I created a required People and Group column. Is there a way to enter "N/A" or a sample name instead of entering a active name from the AD? Its a required field can't leave it blank.
4
votes
2answers
127 views

Is there a tool that helps with Modern UI column formatting?

It seems like the new column formatting JSON-based solution is much more inferior in comparison to the old client-side rendering with JSLink. I am mostly talking about dev experience. For example, ...
0
votes
1answer
138 views

Invalid Field Name error when creating Sharepoint page

I'm trying to create a new Sharepoint page but I am getting the following error: Invalid field name. {50631c24-1371-4ecf-a5ae-ed41b03f4499} .../Pages TECHNICAL DETAILS Troubleshoot issues ...