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

2
votes
1answer
42 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
27 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
8 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
13 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
21 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
41 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
95 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
16 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
22 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
35 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
22 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
33 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
42 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
12 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
129 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
44 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
23 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
13 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
19 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
18 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
25 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
30 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
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
96 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
67 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
27 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
19 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
35 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
173 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
44 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
27 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
14 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
20 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
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 ...
0
votes
3answers
57 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
67 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/?...
1
vote
1answer
49 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
97 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
57 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
1answer
113 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
1answer
64 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
33 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
156 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 ...
1
vote
3answers
49 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
54 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 ...