Stack Exchange Network

Stack Exchange network consists of 174 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
Make your voice heard. Take the 2019 Developer Survey now

Questions tagged [column]

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

1
vote
2answers
33 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
9 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
30 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
38 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
18 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
11 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
17 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
16 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
21 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
29 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
22 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
18 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.
3
votes
2answers
69 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 inveriour in comparison to the old client-side rendering with JSLink. I am mostly talking about dev experience. For example, ...
0
votes
1answer
43 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 ...
0
votes
1answer
17 views

Verify Date Selected Is atleast 3 Business Days Away

We have a SharePoint site that we use to schedule customer appointments. These appointments need to be scheduled on a weekday and need to be at least three business days away, but no more than 45 ...
2
votes
1answer
17 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 ...
0
votes
2answers
16 views

SP Folder Status Indicator

Would it be possible to create a column on a SP folder as a status indicator i.e. review completed. Thank you.
0
votes
1answer
32 views

Cannot Remove Field from Sharepoint AddIn

I have a provider-hosted SharePoint Online add-in project. In this project I have added a lookup field with name CaseLawyer and deployed the app in the site. After that, I have deleted this field form ...
0
votes
1answer
94 views

Using JSON data bars Column formatting for text (stages)

I am looking at using column formatting to allow us to easily identify which stage a project is in. In SharePoint online using modern views. We have 4 stages and would like to have a 25%, 50% 75%, ...
0
votes
1answer
22 views

Bring list Column headers back

Following a great tip from How can I get rid of the columns header when the style 'Boxed' was selected? I was able to hide all the column headers and everyone was happy! Until of course ...
1
vote
0answers
30 views

Make column locked for editing by users in Sharepoint list

I currently have a SharePoint list that track open tickets for specific events. I have a flow that runs on this when an item is added. The flow creates an automatic due date (+5 days from when ...
0
votes
1answer
26 views

Code customizing

I have a document library with a deadline column and a status column. If the deadline expires, the date will be red (see code). Now, additionally, when the task status is closed, the date should turn ...
1
vote
0answers
13 views

Multillingual column name becomes internal name

I have a problem where a column used by a couple of content types is correctly named Document version when the user views the page in Swedish, but the display names becomes the internal name ...
0
votes
2answers
17 views

What validation code should I use such that if any Column entry is changed it shows an error ?

I'm basically trying to keep 5 columns of my list locked(uneditable) while the last column editable. I'm a beginner and thought this would be the easiest way to achieve this. Do kindly suggest any ...
1
vote
0answers
17 views

SharePoint 2016: filter on managed metadata column with AND operator

We are using SharePoint 2016 and have a document library with a multiple managed metadata column. In this document library we try sometimes to filter on this column. We can select 1 or more terms in ...
0
votes
0answers
27 views

What is the Copy Source column for and why is it empty?

I have seen this question semi-answered here: What does the "Copy Source" column mean in a document library/list? and logically it makes sense, but I have tested it out and nothing appears ...
0
votes
1answer
14 views

Truncate with a twist

I've been browsing this site for two days now with no avail to my problem. I have a SharePoint 2013 on premise site with Designer Workflows only. This site for reasons I cannot go into is very ...
-1
votes
0answers
61 views

Freeze first column in custom list view in sharepoint 2016

I read couple of days in this topic but found no solution so far. I have a custom list "employee database" with 105 columns. I use spoodoo sticky headers (http://spoodoo.com/sticky-headers-sharepoint-...
-1
votes
0answers
19 views

Rollup image showing html code instead of physical image in list view

I have some code(Sharepoint 2013 high trust provider hosted add-in) that creates a list and adds some fields to it. One of the fields is a rollupp image/Publishing Image that i add with this xml ...
0
votes
3answers
48 views

Check SharePoint lists are identical

Is it possible to check two SharePoint lists are identical in terms of list columns(Column names and types) programmatically?
1
vote
2answers
45 views

Set list column permission in different views of the same list - sharepoint 2016

In sharepoint 2016 I have a list with several views each targeting different audience. I need some solution to manage column permission in new/edit/display forms. I tried https://archive.codeplex.com/?...
0
votes
0answers
25 views

Sum of multiple columns individually in a SharePoint List

I have a list with several accounts in it that have daily entries in each account. Each account is a column in my list. What I would like to do is sum to total of each column somehow. I have done this ...
1
vote
1answer
43 views

How to create columns that pull 'Authors' and 'Last saved by' metadata from a word document

In a document library, is it possible to create a new column that pulls this data from the files properties? I’ve tried adding 'Author' from existing site columns and creating my own single line of ...
0
votes
2answers
70 views

sharepoint API rest custom column http 400

I have a list in sharepoint, where I have put the totals of the columns I am interested in. ID Count=50 Certification Count=9 I want to display these counts on another page. I have found a code to ...
0
votes
1answer
38 views

Unable to hide custom columns in Discussion Board

I have added some custom fields to a Discussion Board list in SP 2013 that are populated using Workflow. I do not want these to appear in any of the create or edit item views. I have marked the items ...
0
votes
0answers
16 views

SP2013: Add existing site column to existing page using PowerShell

I'm working with a custom article (publishing) page layout. I'd like to add several existing site columns to an existing (article) page. It's currently set up in a very unpractical way that only ...
0
votes
1answer
78 views

Sharepoint Site columns how do i add a year in our column

I want to add 2019 to 2020 look upon our YEAR column. Please assist
0
votes
0answers
27 views

Update Sharepoint column using R

I have an Excel file that I am autopopulating using R and then uploading to my SharePoint site using the "openxlsx" package. After saving this item to SharePoint, I want to automatically set some of ...
0
votes
1answer
38 views

Disable fields based on choice *that may have multiple choices*

Is the title weird-sounding? It is to me. But, here's my situation: I would like to disable (in some way, greying out, or whatever) certain fields in a list based upon a CHOICE field I've got at the ...
0
votes
2answers
31 views

Creating fields that are automatically populated based on the value in a Lookup column

I have two SharePoint lists. List #1 contains "static" information such as project number, geographic location, region, and planned inspection type. List #2 is a list that I want to use as a way to ...
1
vote
3answers
90 views

Sharepoint traffic light

My boss wants me to make a traffic light system inside a list, which changes colour depinding on the values of a column, using javascript(has to be javascript!) in sharepoint 2013. I found a guide ...
0
votes
0answers
62 views

Updating list column using C#

What I have I have two lists with the following columns: listA - 'employee name', 'project' and 'department' (depratment is empty now); listB - 'project' and 'department'. Projects are assigned to ...
1
vote
3answers
44 views

Sharepoint 'content type' not available as a column

I would like to quickly filter by content type (on sharepoint online) in my document library, but I can not find the column 'content type' anywhere.
1
vote
1answer
53 views

How do I edit colum in SharePoint Online using JavaScript?

Hope you're well; What is javaScript code to add on SharePoint list for showing a few lines of text per row so they all the same size where reams of text have been written this is via scroll or ...
0
votes
3answers
38 views

SharePoint: Can’t display custom column value in Search Results

Good Day! I have the List on SharePoint Site. It’s enabled for showing in search results. I see its elements in Search Results Page. I would like to show my custom column values in Search Results. The ...
2
votes
1answer
80 views

Need assistance: JavaScript Code

Code work whell before i add to code: items[i].get_item("SITE") I can take ID from code, but not a column element. What have I do bad. Here is a code: <input type='button' id='123' value='Pokaż ...
-1
votes
1answer
36 views

JavaScript code on working on SharePoint Online list

Hope you're well; I am adding JavaScript code into content web part. However it is not working. I'm i mising something out.
0
votes
1answer
273 views

Auto-populate an existing column based on another column using data from different list

I have two lists filled with data (listA and listB). A is a list of people with column 'DepartmentName' in it. B is a list of departments with columns 'DepartmentName' and 'Building'. I want to ...
0
votes
1answer
53 views

JavaScript on SharePoint list

hope you're well; What is javaScript code to add on SharePoint list for showing a few lines of text per row so they all the same size where reams of text have been written this is via scroll or ...