Questions tagged [column]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
768 views

Can field in form autopopulate based on other field's drop down selection? Both fields are from the same list

I have a form that's pulling in items from different columns of this list:![List][1] On the form, you have the option to select Job Title and, later on the form, Systems Access, ![Categories][2] Since ...
0
votes
2answers
875 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 ...
2
votes
1answer
728 views

Set Web Part Page Columns for Equal Width

I have a web part page with header, footer and 3 columns. I want the three columns to be of equal width. I have searched but can't find and simple CSS code to apply. I don't have access to SPD. ...
11
votes
5answers
8k views

Can I add a start workflow link to a column in a list view?

I would like to add a link directly to a start workflow page in a column so that users don't have to go through several clicks to start a workflow. The link needs to change based on the item ID for ...
3
votes
4answers
8k views

Calculated column that updates daily

Is there a way to make a column in a list that updates daily with the current date? If not what's the best way to do this? I was thinking of using the 'Lookup' field to link to the calendar that's on ...
0
votes
2answers
38 views

Help with calculated columns

I have two columns in my SharePoint list called name and email, So I want to have the name be the display name and have the value of the email. So when a users selects a name he or she won't see ...
1
vote
2answers
1k views

How to set only positive number in sharepoint 2013 column

The column Title has default setting as single line text. I would like to set validation as only positive numbers allowed, no decimal. I've tried with =ISNUMBER(PurchaseQty+0) but I still can key in ...
0
votes
1answer
254 views

Strict Text Formats in SharePoint Online

In my SharePoint Online list I have column Serial# and I want Serial# in a specific format like 5CB34307L8, 2CE0031NWX For example if I type 512,bc1 it should be converted automatically into 512BC1 ...
0
votes
2answers
35 views

Count Number of Items of Specific Value and update field in another list

I am stumbling with this in a huge way and I'm hoping someone here can help. I have a SharePoint List that has two fields I want to collect data from. The first field in Location and the Second is ...
0
votes
1answer
900 views

Deleted “Resources” Column and now site gives error

I've deleted the Resource column in my calendar list and now, when I have Use this calendar to share member's schedule checked YES, I get an error: Unable to retrieve 'Resource' field from the ...
0
votes
1answer
971 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
2answers
31 views

Is there a way to remove white-space from the Text?

For example, If I give input text in the Column as - mo bi le pho ne. Then the data should be saved in the column as- mobilephone (it should remove all the white-spaces) Also, the Validation formula ...
2
votes
3answers
4k views

Custom list quick edit missing one or more required column

I am trying to create a custom list that is editable in quick view, only three columns are required (Project Name, Project Start Date, Project Estimated End Date)and I am trying to display it in a ...
1
vote
1answer
30 views

Unable to delete Column

Forgive me if this has been asked before but I have not been able to find a solution that works. I am currently teaching myself how to use SharePoint. I have created some columns that have errors in ...
0
votes
2answers
1k 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 ...
0
votes
2answers
147 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 '...
0
votes
0answers
7 views

Want to Update Drop-Down Column Selected value with Single Item (Record) Collection Column name Quantity in Power Apps. Need Help

As beginning I have attached the List to the gallery & Copied the Selected Row (all Columns) as per my choice into Collection(ChooseItems) in one Screen. I have selected many rows from Gallery and ...
1
vote
1answer
913 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 ...
1
vote
3answers
3k 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
22 views

Update column based on file views in document library

I have a document library with a bunch of files im sharing with others. I have a column called "Opened" which is based on a yes/no value, and it defaults to no for each file. I'm wondering how I can ...
0
votes
1answer
23 views

Is it posible for a document set to inherit metadata from a document which is inside this document set

I'm running in to this problem where people want to add metadata to a document using that same document. This is possible using Word quickparts. Now for the fun part, the documents are inside a '...
0
votes
1answer
24 views

How to mask a field like SSN or ID field?

Is there way to mask a field like social security number or ID field? I like mask field both in list view level, edit form and view form. Is it possible? Sharepoint 2013 (we have nintex form as well)
0
votes
1answer
19 views

Column Validation/Validation Settings, How can I add a formula where if one answers YES to one column it will require them to fill out certain columns

I have a sharepoint list where I have a series of questions. The first question in the series is a YES/NO question, and it states if the answer is no, there is no need to answer the next few ...
0
votes
0answers
19 views

Unable to set User SharePoint group column (lookup) value

Would like to request for some assistance in SharePoint. I have a SharePoint group called Users and SharePoint List called Role and Department. I have added Role and Department to Users column as ...
2
votes
1answer
45 views

[PnP][SharePoint] How to add a column to all content types of a list?

I have a list in SharePoint with 50 content types. My list has two columns that I want to add to each content type in my list using PNP library. Until now I have something like this: Add-PnPField -...
0
votes
1answer
9 views

Infopath-Populate ID from SharePoint List

I have an InfoPath 2013 form with multiple views with a lot of fields for users to fill out. My final page after the user submits the form through the main data connection is a view that says "Thank ...
0
votes
0answers
6 views

Enable Table Styles Group for enhanced rich text field

Good Day, I have enhanced rich text field in some SharePoint List. I can insert table to this field, but Table Styles Group is grayed out. How can I enable Table Styles Group for rich text field? I ...
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 ...
4
votes
1answer
3k 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
24 views

Create a column unique to only a single folder within a document library

I am currently working on a standalone project that has numerous documents that will reside within the project folder located within my organizations document library. Below is an idealized example ...
0
votes
1answer
25 views

Custom Validtion syntax for the IN operator for a column of SharePoint list

I am trying to find out how can I write a code to restrict a user to enter a value among a set of predefined values (i.e. IN Operator) in a column of a SharePoint list. My column name is "Asset type" ...
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 ...
0
votes
2answers
38 views

Make SharePoint Online list columns read only based on yes/no checkbox

I have 7 columns that I need to make Read Only (greyed out) as soon as the item is saved when "Field 7" is ticked (yes/no checkbox column). I have managed to make these 7 columns read only using the ...
0
votes
2answers
86 views

Need to grab address column and pass it to an array

My script uses an array like this: var locations = [ ['Location 1 Name', 'New York, NY', 'Location 1 URL'], ['Location 2 Name', 'Newark, NJ', 'Location 2 URL'], ['Location 3 Name', '...
1
vote
1answer
23 views

How to validate a column based on the value in another column?

I'm trying to come up with a formula that could validate a column. I have a form in SharePoint to register parcel shipments. There's a column that contains a shipment code (values 1, 2, 3). If the ...
0
votes
1answer
853 views

Sharepoint Online - Recover column from lists of project sites

I have a site collection with a lot of subsites attached to projects (each subsite is a site created by a project). Those subsites has a list with its fields. I executed a PowerShell script that ...
1
vote
0answers
15 views

How to update the External Content Type of existing column

I have a list with multiple columns as the type of External Data. There are some changes in the External Content Type. so I want to update the reference for some of the columns. But I am not able to ...
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
4answers
1k views
0
votes
2answers
731 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
4k 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 ...
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 ...
2
votes
2answers
3k 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
18 views

Remove 'Target Path' Column

I have a colleague that created a list that I inherited. It was created as a task list, and comes complete with the column 'Target Path', which is not only a required field, but I cannot seem to ...
1
vote
1answer
31 views

Changing Hyperlink Column based on InfoPath forms

I have a requirement from my client that's unlike anything I've done in SP. So, I'm re-designing their Change Request system. I've build a form with multiple views in InfoPath that serve different ...
0
votes
1answer
2k views

Sharepoint List Calculation #Div/0!

I have a Sharepoint list which contains a field which is calculated based on two other columns. However when the two other columns both contain zeroes the result comes out as #DIV/0!. The actual ...
0
votes
1answer
636 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 ...
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
1answer
705 views

How to change list column that is defined as multi-line to single line input

I have imported an excel document into SharePoint 2010. One of the columns was automatically defined as being multi-line, but I want it to be single line input instead. I have looked at redefining the ...
3
votes
1answer
702 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 ...

1
2 3 4 5
21