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

0
votes
0answers
6 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
19 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
34 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
25 views

Column Formatting Option not available

I can't see an option for format column where I can enter JSON codes.
1
vote
2answers
54 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
78 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
16 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
48 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
31 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
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
23 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
67 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
150 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
18 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
24 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
92 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
26 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
34 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
45 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
13 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
215 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
55 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
20 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
19 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
31 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.
4
votes
2answers
109 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
91 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
28 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
17 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
203 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
56 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
28 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
15 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
22 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
62 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
77 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
54 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
121 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 ...