Questions tagged [column]
columns (fields) created using out-of-the-box column types
359
questions with no upvoted or accepted answers
6
votes
3
answers
69k
views
SharePoint Online, Change Column Widths On Custom List
I have created a Custom List via Importing Excel Spreadsheet.
How do I adjust the column widths?
I tried to follow the below link, (my view is AllItems.aspx) and it never shows me the menu outlined ...
5
votes
0
answers
131
views
Multiple validations in a single column in 2013
I have been working on something I feel should be very simple for far too long. I have a single line text column in a list and would like to employee multiple validations to the column. The ...
5
votes
1
answer
4k
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"
...
4
votes
0
answers
535
views
Highlighted content - how to filter by custom column?
We use SharePoint as a wiki. So we create modern pages in the standard library and in a newly added column we specify that it is a wiki page. The views are filtered accordingly so that only wiki pages ...
4
votes
1
answer
387
views
How do I validate Start and End Dates by column?
I have a site where employees input schedule items, each with a Start Date and End Date. I would like an error message to appear when users select an End Date before the Start Date. What formula can ...
4
votes
1
answer
298
views
How to retrieve column names in other languages with CSOM?
I am trying to retrieve display name of a column in all languages available in my SharePoint installation (currently English and German).
internal static void TestColumn(Microsoft.SharePoint.Client....
4
votes
0
answers
142
views
Pasting into a metadata column
So I am moving our phone inventory over to SharePoint, and I have created numerous columns. Three of the columns use metadata, and so when I paste the items into the field I get the little red box ...
4
votes
1
answer
493
views
How to send email to people from choice column with multiple selections
I would like to choice people from choice column with multiple selections and then send email to these people by using workflow SPD.
Can I do it?
I use SharePoint Foundation
3
votes
1
answer
173
views
Document Library Required Columns
I'm trying to organize a document library by using different columns of information. I have two columns that are drop-down menus and one column that is a single line of text, all of which I set to be ...
3
votes
0
answers
1k
views
How can I create a traffic light status column
I want to create a traffic light status column in my task list. I have referenced the Path to SharePoint solution (and most of the others out there) but using a calculated column to display HTML and ...
3
votes
0
answers
71
views
Exception by setting a column unique
I have a huge list, about 200000 items. Till yesterday a custom column called Nr was not unique and contained many doubles. Today I cleaned it removing items with double entries, tryied to set the ...
3
votes
1
answer
842
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 ...
3
votes
1
answer
170
views
Set value of "column b" with "column a"
I would venture to guess the answer to this is no but I am going to ask anyway...
Is there any way, without an event handler, to set "column b" equal to "column a" without changing the default value ...
3
votes
0
answers
908
views
Upload pdf file and automatically create list columns in a SharePoint list
My requirement is :
When a user uploads a pdf file into a document library. There is a table in a pdf file which two columns. The SharePoint should understand and create list columns from the first ...
3
votes
2
answers
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 ...
2
votes
1
answer
431
views
SPFX - Update list with a new field fails
I'm trying to deploy a new field (column) to a custom list that has been deployed using a SPFx Extension. The field gets added to the site, but it does not get added to the ContentType.
I've been ...
2
votes
1
answer
44
views
Do File Libraries have any column types that can be modified after approval?
I have a Doc Library with versioning, content approval, etc. that gets updated with a Flow/Power Automate after the user has checked-in.
I want to have a column or two that are not doc properties and ...
2
votes
0
answers
420
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 ...
2
votes
0
answers
1k
views
Using a workflow to automatically create document folders each time a new list entry is made
I'm new to sharepoint developer, so I'm hoping someone is able to guide me (provide simple instructions!) on whether it's possible to create a workflow where once I enter a new item in a list, a new ...
2
votes
1
answer
604
views
First letter of internal name of list column converts to _x00XX_
I need to create two new columns in a standard list, one is called "AB12" and the other one "AB13". But when I create them, the internal names of them turns into "_x0041_B12" and "_x0041_B13". It ...
2
votes
1
answer
314
views
Hiding specific column in search results
How do I hide specific column when user search for an item?
For example, user searches for other people's names and the personal detail comes out but some detail should be hidden such as email.
Is ...
2
votes
0
answers
98
views
Unable to search managed properties for a document library
I have a document library with metadata that seems to have managed properties. I want to be able to search these managed properties. For example, I can do 'Filename:docx' and it shows only word docs....
2
votes
1
answer
192
views
How was a user able to enforce a unique value for a choice column?
I have a document library with a choice column with possible values. In library settings, I have selected 'No' for both 'Enforce unique values:' and 'Allow 'Fill-in' choices:'
A user was still able ...
2
votes
2
answers
21
views
Unable to update values in a column after minimum requirement was changed
I'm using SharePoint 2010. I had a number column set to require a unique entry with a minimum value of 5000. After about 40 entries were made to the list the minimum value requirement was changed to ...
2
votes
0
answers
37
views
Fields are not displyed in Disp/EditForm after content type upgrade
I had content type based on Page and pages library, which uses this contennt type. I needed to add new columns to this list.
I created Elements.xml for fields:
<?xml version="1.0" encoding="...
2
votes
1
answer
890
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. ...
2
votes
0
answers
54
views
Can I Modify the Output of SP2013 Field Values in Snippets or Page Layout?
I would like to know if there is a way to modify the output of page fields in SharePoint 2013 from within a snippet or within the page layout.
I have a field of type Hyperlink or Picture.
I want to ...
2
votes
2
answers
4k
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 ...
2
votes
0
answers
946
views
Aligning column headers(titles) with row items
I have a list in which the items are long string of characters. Due to this the Column titles are not perfectly aligned with item rows. The Column headers are not changing there original position and ...
2
votes
0
answers
965
views
create a view that groups multi choice column values
I apologize in advance if I am breaking rules by asking a question similar to one already asked (SP2013 - Create a view that groups based on individual selections in a multi choice field). I can't ...
2
votes
0
answers
96
views
How is the relative list item order calculated from tp_ItemOrder column?
I am using a custom action and the Reorder.aspx page to provide a sorting-functionality to my users. I followed the instructions that can be found here: https://niftit.com/blog/how-to-reorder-a-...
2
votes
1
answer
196
views
How to limit End Time to within +8 hours?
I am trying to limit the End Time of a Calendar Event to be within +8 hours of the creation time.
I've used this formula =AND([End Time]>=TODAY(),[End Time]<=DATE(YEAR(TODAY()),MONTH(TODAY())+2,...
2
votes
0
answers
179
views
Difference between ArticleStartDate and Publish startdate columns
What is the difference between these columns:
ArticleStartDate:
<SharePointWebControls:DateTimeField id="ArticleStartDate" FieldName="ArticleStartDate" runat="server"></...
2
votes
1
answer
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
0
answers
189
views
Removing People from User Field, Allow only group
By default, there are two options available for User field.
User
User and Groups
Is there any programmatic/declarative way on changing the properties so that the user field will only suggests and ...
2
votes
0
answers
1k
views
Changes to List Columns not Updating to Content Type
I have a document library with a Document Set content type in it. I created a bunch of custom columns in the list, and added them to the document set. I have changed the display name of some of the ...
2
votes
0
answers
138
views
Setting Required Managed Metadata Column to hidden with default value?
In a Content Type, I have one managed metadata column (which is required) I want to set it with default value and set it to hidden using powershell. I want to clarify if it possible to hide a required ...
2
votes
1
answer
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 ...
2
votes
0
answers
678
views
Filter.aspx and GetDistinctValues
We found an issue, that filters on columns are stop working. Error message is:
Cannot show the value of the filter. The field may not be filterable,
or the number of items returned exceeds the ...
2
votes
0
answers
75
views
Is there a setting on SPField that would prevent it from being included in a CAML query?
I'm trying to build a CAML query for a managed metadata column. I'm following the guidelines provided here by Microsoft. Essentially they say to query for the term's Wssid. No problem, I can do ...
2
votes
0
answers
756
views
Sharepoint Designer Set Task Field drop-down is showing empty
Using SPD 2010 I created an Approval process. I have added few custom field to my task list and now under "Before Task is assigned", the action "Set Task field" is not showing anything on the dropdown-...
2
votes
0
answers
109
views
Why the Required property of field is changing to false?
I created site column with Required="true". Then I created site content type and added my column to it . Then I created list, selected "Allow management of content types?" to "Yes" and added my ...
2
votes
1
answer
430
views
Value of User field changed after copying to another list cross Site Collections
The value of owner field of a document is beeing changed when I copy a document from a library to another library which belongs to another site collection than the original library. I copy the ...
2
votes
0
answers
156
views
Best way to create a list with hidden columns with Data pulling from InfoPath form
So I have been working on this for a little bit here is what I am trying to accomplish:
Using OOTB SharePoint 2010 Functionality I want to create an HR Referral System. Basically an InfoPath Form ...
2
votes
0
answers
719
views
Updated = calculated field based on Modified shows 1899 last update
Working with SP 2010 and had to remove the time stamp from modified. Tried at system level - no joy. Used a calculated field (=TEXT(Modified,"mm/dd/yyyy")). This works well but occasionally shows the ...
2
votes
0
answers
90
views
Using resx file in Calculated Field
Is it possible to use resource file (.resx) in tag?
I made a calculated field and want to show the result in some different languages.
2
votes
1
answer
683
views
How do I configure required columns on Wiki pages?
In a SharePoint 2010 Wiki page library, if I add metadata columns to the page library, something like "Category" and make it a required column. When I go and create a new Wiki Page in that library I'...
2
votes
1
answer
140
views
Hide empty columns in PerformancePoint Scorecard dynamically
I have a scorecard with several empty columns which I want to hide dynamically.
In the illustration above, I want to hide three empty columns, viz. MidYear Income, MidYear % and MidYear Status.
...
1
vote
0
answers
51
views
SharePoint list search for choice columns
I am having an issue with searching a list based on the contents of a choice column. I seem to be able to search by text-based fields, but I have an important field called Category that is a choice ...
1
vote
1
answer
407
views
SharePoint online column formatting seems to affect Edit In Grid view
Even the most basic JSON column formatter seems to make the Edit in Grid view search results list box render blank. I've tried using @currentField.lookupValue as well as much more complicated ...