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

learn more… | top users | synonyms (1)

0
votes
1answer
38 views

Force “Name” field in SP13 Library to be equal to '“Title”

As I understand, SP13 searches documents by document Title. When you upload some document to the library, you have to fill in "Name" and "Title" ( the same field twice). What I want to do is to ...
0
votes
1answer
26 views

How do I know which Columns are safe to delete because they are used by a removed content type?

This list used to have content types (A & B). We have now deleted all list items that were content type B. I have turned off Management of content types. Columns for content type B still appear in ...
2
votes
1answer
37 views

Calculated Columns - IF statement to find all numbers inbetween a selected area

Since my title is unclear let me explain. I'm currently trying to work out if I can use an IF statement to find numbers inbetween a selected amount. Example: =IF([Weeks Left]="1-12","coming soon",...
0
votes
1answer
66 views

Allow multiple selections on Person or Group field

In SharePoint 2013 on-premise I am trying to create a Person or Group field to use it in a content type. My problem with the field is that I cannot select more than 1 person. I have been googling a ...
0
votes
4answers
38 views

How can i make SharePoint Calculated Columns to know who edit some columns data?

How can i make SharePoint Calculated Columns to know who has edited some columns data? I want to know who is editing specific columns, not modified by, and not using version history on each item. ...
0
votes
0answers
13 views

Percentage calculated column issue

My code is =IF(OR(Agency="1",[Day Rate ex VAT]*(1-90%)), IF(OR(Agency="2",[Day Rate ex VAT]*(1-90%)), IF(Agency="3",[Day Rate ex VAT]*(1-90.5%)))) This code is basically trying to work out if ...
0
votes
0answers
16 views

Display a Date in a Column by selecting one of a choice on the other column

I have added a task app for my project lists. There is one column called "Task Status" with three Drop-down choice: Project Assigned, Project in 90% completed and Project Completed. I wanted to ...
1
vote
1answer
45 views

What SharePoint Column is used for a Video?

Is there a built-in column that is used for a video asset?
0
votes
0answers
13 views

Fields from Infopath form not showing up in site content type columns

So I created a new site content type for a document library in SP 2010 I'm using to store form submissions. I was able to have the content type reference an existing form when creating new items, but ...
0
votes
2answers
54 views

Adding text to a Sharepoint Traffic Light Calculated Column

I currently have a Calculated column that produces a colored circle depending on another column. =IF( ISERR(RIGHT(LEFT(Level,2),1)-1) ,"" ,"<DIV style='font-weight:bold; ...
0
votes
0answers
37 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 ...
0
votes
0answers
37 views

Custom task column on reusable workflow

I had a workflow that was linked to a list. I noticed then that I could make a reusable workflow, which is more practical: I only need to link it to the list that I want, instead of making a new one! ...
0
votes
0answers
25 views

Sharepoint list “Append Changes to Existing Text” + latest Entry

I have a SP list with a column latest updates. This column is set to "Append Changes to Existing Text" with versioning turned on. However, when we go through the list as a team. It's annoying to open ...
3
votes
1answer
73 views

Column validation only when creating new item Sharepoint 2010

So I have a date field that needs to be a future date when the item is created. The formula I have set up for that is: =[Date Required]>TODAY() This works well however I am running into an ...
1
vote
1answer
67 views

How to change the font of column name

Is there a way for me to change the font size/ family for a particular column name for Default New Form web part. (jquery/ SPD) Like the following image (diff from default style) Thanks!
1
vote
0answers
45 views

SharePoint 2013 - Add Library Column Showing Managed Metadata Level Values

I need to be able to classify all the documents in a library into a Major Category and a Minor Category where the Minor is specific, but not exclusive to the Major. It would appear that the best way ...
1
vote
0answers
33 views

Sharepoint 2010 Validation by two fields

I have a SharePoint list with these fields: Destination - User picks a person Created by - User who created the item Is there a way to prevent users from creating item for themselves using ...
0
votes
1answer
244 views

Adding custom column to Workflow Task content type makes workflow stop on assign task

I have been asking a few questions in here lately, as I'm beggining my journey as a Sharepoint Online 'developer' for my new internship. I have a new one for today: I have created a custom approval ...
1
vote
0answers
29 views

Change a field in SharePoint Online

I have identified a site column with incorrect properties. Specifically I need to change the RichText value from FALSE to TRUE. How can I do that? I have tried to locate Elements.xml and edit that ...
1
vote
0answers
18 views

Help with auto calculated field for dates from another column [closed]

I am trying to make a column with expire dates from a date entered in another column. For example I have a column with a date entered for training. I then want another column named expire date that ...
0
votes
3answers
38 views

Calculated Column Question

I currently have a list with the Column - "Level" This column is a choice column with the choices: "Novice" and "Beginner" I'm creating a calculated column called "Score" I want this column to ...
0
votes
0answers
18 views

Create Field which allows choice of values, but value does not change when source does

Using SharePoint 2010, is it possible to create a field which forces the user to select from a dropdown list (based on items in another list), but when the value in the related list changes or is ...
0
votes
0answers
6 views

What is the Protocol Name field on the List app, and how do I automate filling it in?

I am attempting to create a Custom List app in SharePoint but am being stymied by the Protocol Name column that is added by the list by default. I don't have a good understanding of what that column ...
0
votes
2answers
34 views

Setting a field as a hyperlink in a list

I'm attempting to use a calculated column to set the field as a hyperlink. Currently, I'm using this code. ="<a href='"&%URL_Field_Name%&"'> "&[%field_name%]&"</a>" So, ...
2
votes
3answers
346 views

Set default value of Article Start Date to [Today] with CSOM

I'm struggeling with setting the default value of ArticleStartDate date-time column using PowerShell and CSOM. Bakground: I have a content type, used by a page layout, inheriting from Article Page ...
0
votes
2answers
34 views

Column Versions

Is there any way of adding a column to show the previous version of an approval status? I want 2 columns: one to show the current version and the second column to show the previous version of the '...
0
votes
1answer
48 views

Lookup column restriction

For a school project we are setting up a SharePoint for a non profit organisation who handle clients. we have made a document library where we store documents sets for every client thats added. In a ...
1
vote
1answer
43 views

How can I create a [Me] filtered view using a Lookup column with names in it?

Any help will be hugely appreciated as really struggling with this. I am limited by company regulation saying I can't use code so any answer will need to be code free and not require the use of Design ...
2
votes
0answers
27 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-...
0
votes
0answers
24 views

Sharepoint Column Validation Error - Not going to second page

I added column validation to the drop-down choice questions on page 1 of my survey and it worked fine. The last question of my survey page 2 has branching logic and column validation. When I ...
0
votes
1answer
15 views

list columns, diplaying information provided via lookup from one column differently in another

There is a lookup column within my list that allows the results to be displayed in many different ways. Example: Smith, John W or John.Smith or Employee ID#. Is there a way to add another column to ...
1
vote
2answers
52 views

Column validation- User must enter A or B as first character

I am trying to create a validation formula which will verify that the user entered A or B as the first character in the column. Can't seem to get the formula right. Can anyone help? [EDIT] One ...
0
votes
0answers
27 views

columns are not showing when adding from “Add from existing list or site columns”

I want to add some columns to content type from a specific column group. I click on "Add from existing list or site columns" and choose one column group. But below in the available columns list, I am ...
1
vote
0answers
179 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 ...
0
votes
0answers
37 views

Version System column and word information panel

In SP2010 library I have Version system column based which shows version of document. I want to add this column to content type of document, because I want this field to be shown in Word information ...
0
votes
1answer
52 views

Get schema name of specific field in list

How to get Schema name of specific field in a SharePoint list? I'm using SPservices to get list items from the list but one field is missing in the result. I want all field values of the list
2
votes
1answer
43 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,...
0
votes
1answer
89 views

Workflow: how to UNSET (or set to NULL) a date/time type value in a custom column?

Trying to build a workflow that clears a date column when the task "Completed" box is unchecked. Have tried several different approaches but have not gotten anything to work. The workflow completes ...
3
votes
0answers
42 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 ...
1
vote
0answers
54 views

Wrapping text in list

I need to wrap text in my row data. I have found how to do it for the column headers and that is not what I need. I need the data inside the list itself to wrap text. How to do it?
3
votes
1answer
228 views

Can I prevent duplicates to a SP2013 list with a validation formula?

I have a SharePoint 2013 list and want to use 2 columns as sort of a natural key on the list, so when a user enters a new entry, if these 2 columns combined match an entry already in the list, it won'...
2
votes
1answer
26 views

SharePoint List CreateBy column storing date value

we discovered some very strange behavior in a list. within the last couple weeks, the Created By column for all items was replaced by a date: 35;#2014-12-23 23:17:51 I got this using powershell, ...
1
vote
2answers
95 views

SharePoint New/Edit Form Separator

I would like to have some headlines/separators between columns in the New/Edit form in a SharePoint List. Basically, I would like to have a separator in between the categories to which the columns ...
3
votes
1answer
754 views

Check if a Date field is greater than another Date field

I am working on an issue tracking list and I added two custom fields of type Date/Time which allows date only, as follow: Plan start date. Plan end date. How can I check that the start date is ...
1
vote
0answers
16 views

Using the One Column with Sidebar and wish to reduce the width of the toolbar

I am currently using the One Column with sidebar Text Layout and the sidebar contains 3 web parts within it and having reduced the width of the web parts, I wish to reduce the width of the sidebar in ...
0
votes
0answers
53 views

Creating a RYG Colour Coded Sharepoint 2010 column that is affected by dates

A current issue I'm having is creating a column that changes from green to yellow to red based on how much time has passed from when the document was added to the list. I already know how to create a ...
0
votes
3answers
749 views

Show/Hide columns based on dropdown selection

When adding a document I want to show or hide colums based on a dropdown selection. In this case, the value of "Document type" is leading. If a Travel Document (Column name "Travel Documents") is ...
0
votes
0answers
19 views

Lookup field getting value instead of text

I have departments list ,I want to use departments list in another list by using visual webpart it works fine but I am getting values instead of text in the list after saving the list item. in ...
1
vote
1answer
45 views

Hour calculation

I have list with two date fields. It is also containing time information. It is based on leave request so I need to calculate hour basis for half a day leave. If user enters 8/1/2016 08:00 AM as ...
2
votes
1answer
167 views

Powershell to export all the columns with their data values in a sharepoint 2010 list

I have to export all the columns in a particular sharepoint list along with the data contained in the columns. I am currently able to get all column names but not data. Need help with that. Below is ...