The arrangement of data for storage or display.

learn more… | top users | synonyms

1
vote
2answers
10 views

Conditional Formatting Based on Number Range

I'm trying to add conditional formatting to a custom list based on whether or not a field contains a number in a certain range (i.e., if the field contains a number less than 15, i'd like the ...
0
votes
0answers
12 views

conditional formatting XSLT error [on hold]

I am doing conditional formatting on a list through sharepoint designer and it gives this error while changing font color on any column or row condition. please help to remove this error.
0
votes
0answers
12 views

SharePoint WCF service and automaticFormatSelectionEnabled attribute

I am creating SharePoint 2013 Custom WCF service according to this manual: ...
2
votes
2answers
409 views

SharePoint Online “Page Elements” style for Format Text missing

We are currently experiencing a really weird bug where the "Page Elements" is missing under the Font Styles under Format Text. Here is a screenshot: The weird thing is, it was working fine ever ...
9
votes
4answers
9k views

Color code item row based on column value in SharePoint Foundation 2013

I have a custom list which contains a field called Status. In the AllItems view, I would like to color code each line item based on the value of Status. Is this possible to do withing SharePoint ...
0
votes
1answer
656 views

Conditional formatting lookup column

I am attempting to do conditional formatting in a list view in SharePoint Designer. In this list I have a list that contains a lookup column, and other columns derived from the list of that lookup ...
0
votes
1answer
22 views

Jquery to display formatted value in content editor

I'm completely new to jquery and by now I'm not able to use it. Can anyone help to write a piece of code, which will display single item (given ID) from the list 'CounterList', column 'Counter' to a ...
0
votes
1answer
22 views

How can i make a server folder path opening in file explorer using IE and SharePoint List?

I'm approaching SharePoint just now, i have this List with our actual and running projects, every project has a specific folder address on our server. I want to make that folder opening in file ...
2
votes
1answer
33 views

Link to Edit button on page for item & conditionally format

In SharePoint Online (E3 subscription) I have 5 lists in a site and in each list the user is to enter 1 item. The end result is to enable the Create and Edit button conditionally on a page next to ...
0
votes
1answer
77 views

How to remove time stamp from date field in InfoPath form?

I have a drop down in an InfoPath form that grabs data from a SharePoint list. One of the fields in the form is a date field and when it gets populated with the date from SharePoint it includes the ...
2
votes
1answer
76 views

Format Date in Content Query

I have looked through too many threads about this and have made no progress. So far the following links have helped me the most: Content Query WebPart & Date How to format Date in Content ...
0
votes
2answers
3k views

conditional formatting with advanced rules

I need to format rows in a list, based on the due date and status. If a task is not completed and there is still more then 7 days time it should be green. If a task is not completed and there are 3 ...
0
votes
0answers
29 views

Modify List Formatting

I don't know too much about SharePoint, but I've been tasked with changing the formatting of a list we have on our site. The list is used on multiple pages and each page has a different view. The ...
1
vote
2answers
85 views

How to stop Sharepoint from auto formatting my code?

I would like to format my code by myself so it is easier for me to read the code, rather than having SharePoint formatting my code automatically, and it is hard to read.
1
vote
1answer
8k views

How do I apply conditional formatting using SharePoint Designer 2013?

I'm attempting to apply Conditional Formatting to a list view web part via SharePoint Designer 2013, and I can't seem to find the option to do so. I've a horrible feeling I'm just being daft, but ...
0
votes
0answers
22 views

Is it possible to use inline-blocks in SharePoint?

Is it possible to use inline-block in SharePoint? I am trying to use them but it keeps formatting the code, and adding a space (&#160) to my div tags which messes up the inline-blocks. Here is an ...
4
votes
2answers
14k views

How to add hide/show section toggle to InfoPath form?

MS Word 2013 has this great feature. You can define sections of a document with Headings. You make certain lines headings by highlighting the text and choosing the Heading 1 Style from the ribbon. ...
1
vote
2answers
685 views

How can I format phone numbers in SharePoint 2013? [duplicate]

I'm wanting to format a column in SharePoint 2013 to automatically enter the parentheses and dashes in a phone number. So no matter how the telephone is entered, it shows (###) ###-####. Thank you ...
1
vote
2answers
71 views

How to format hyperlinks in blog comments?

SO and GitHub have an easy way to format hyperlinks by hiding the URL behind some descriptive text by enclosing the text in brackets followed by an URL in parentheses. How can I do something similar ...
0
votes
1answer
511 views

Use FormattedString with FormField in view/edit form

I am trying to format a Sharepoint:FormField in a view/edit form and used FormattedString, but it doesn´t work. I do this because I would like to display a number without comma separator. ...
3
votes
1answer
255 views

get_fieldValuesAsText usage example

I need to get items using JSOM and show them on a page in a display form. So currency field will be shown like $ 123,456.78 the date will be formatted accordingly to settings and Yes\No value will be ...
0
votes
0answers
11 views

Conditional Formatting code for percentages [duplicate]

I have a SharePoint 2013 question on conditional formatting code. I would like to have percentage font 85% - 100% in green, and 84.99% on down in red. The problem is if set to display as a % it ...
0
votes
0answers
48 views

JL Conditional Formating for SharePoint 2013

I have a column of percentages in a list. 85.0% on up is in green font, and everything 84.99% and under is in red font. The problem is if set to display as a % it stops evaluating it as a number and ...
1
vote
0answers
66 views

Configure search to show particular cells of a list

This might be some kind of a stupid question, but I'm absolutely new to SharePoint and I've no idea what to do. I uploaded a list to my SharePoint and added a search scope for it. Now I can search, ...
0
votes
0answers
20 views

Formatting issues when uploading excel tables

I am uploading an excel table with 4 columns to a sharepoint list. The first three columns are text, and the last column numbers. When I go to upload, it says that the middle two columns will be ...
1
vote
0answers
82 views

Sharepoint Custom List conditional formatting date comparison

I am having an issue when creating conditional formatting using SharePoint Designer 2010. When the @Complete_x0020_Date is less than or equal to @Negotiated_x0020_Date, it will color the ...
0
votes
1answer
46 views

How do I show a calculated field along the same baseline as preceeding text?

I am new to infopath and so I may be missing something obvious... I have a combo box with sample data, and a calculated formula which binds to the value of that combo box. There is text before the ...
1
vote
1answer
667 views

Date Time format confusion in my SharePoint 2013 server

I want all my date columns in the entire server to be in 'DD/MM/YYYY' format. So I setup the Locale in the regional settings as 'United Kingdom'. I did the changes in the following locations: ...
0
votes
1answer
23 views

How do I duplicate the formatting of a Web Part?

I'm building a page with tasks for my team and I can't figure out how to copy the Task Web Part formatting to each of the other team members. At the moment I ams doing this by hand setting: Web Part ...
1
vote
1answer
86 views

Format List Calendar View Days

We'd like to format the calendar view of a list not off the data entered for each of the days, but off the actual day of the week. For example: Saturday and Sunday boxes would be red Monday boxes ...
1
vote
0answers
93 views

Validate that text field matches a format zero or more times

I have a "single line of text" column in my list that needs to contain zero or more numerical values, separated by semicolons, with no spaces, letters, or other characters. The contents of that column ...
0
votes
1answer
867 views

Date Format 'Bug' In Lists?

I have a calendar with a date & time field called Departure that a user fills when they add an item. For display purposes, my list view uses a calculated column with ...
0
votes
2answers
503 views

How to suppress display of comma when rendering a number column?

This is for SP2010. I have a custom content type which has a column defined as a Number column type. For other business reasons, it does need to be a Number type, so switching it to "Single line of ...
1
vote
0answers
67 views

Apply CSS to all Choice Checkboxes [closed]

I have a choice field that allows multiple selections and users to add new values. I'm trying to put a red border around all of the checkboxes (long story why I need it). Previously I've done this ...
0
votes
1answer
56 views

SP 2010 - Lookup Column not working with Conditional Formatting

I have a lookup column for Tabs: Major Sub-1 Sub-2 Sub-3 Technical Pricing I need to setup conditional formatting so the row color changes with the level of tab selected. I can do this with drop ...
0
votes
0answers
15 views

How do I hide the text formatting in my shared calendar?

Our shared calendar now shows all the text formatting. How do I hide this formatting and not delete it?
1
vote
0answers
110 views

Can the hover/active borders of form fields be customized and/or disabled?

I'm really not crazy about field borders in forms. In InfoPath, you can get rid of the borders, but then the row heights jump in the browser once the form is published to SharePoint. ...
0
votes
1answer
703 views

Number formatting in Sharepoint list

I have several large Sharepoint lists that I imported from Excel, the first column of each of these lists is "Customer Number" these numbers uploaded in the form 1,000,000 and so on. I want to ...
0
votes
1answer
970 views

Conditional Formatting not applied to web part?

SharePoint Server 2010. In SPD, I have applied Conditional Formatting to a document library row, so the background changes color based on a column value in the row. Works great when viewing the ...
2
votes
1answer
43 views

SharePoint 2007 Web parts view size

Can the view of web parts be zoomed in or out? I have a named Excel Chart displayed in an Excel Web Access web part. The chart appears very large in the web part. Is there any way to adjust the ...
1
vote
1answer
87 views

Can I lock the cells size in a datasheet view?

I'm working on Sharepoint2010. I have a datasheet which users can edit free. However I've noticed that everyone can change the size of the cells and even add other columns. How can I prevent any user ...
0
votes
1answer
3k views

Conditional Formatting using Calculated Column as Condition (SharePoint Designer 2010)

I want to use conditional formatting to change the color of a row based on a Calculated Column. I know I could do this with a CEWP but I would prefer to do it in SPD 2010 because I am new to ...
2
votes
1answer
54 views

How do I get a placeholder of 0?

I want my InfoPath form to have numbers formatted like "010" instead of "10" to then sync with SharePoint. How can I get my form to show the zero placeholder instead of two digits?
0
votes
1answer
371 views

Conditional formatting displaying correctly in SPD but not in page

I have been attempting to create status indicators in Sharpeoint Designer 2010 using two background images (red and green circles) in a hyperlink column and conditional formatting. The idea is that ...
0
votes
1answer
44 views

Paste code into a discussion?

I have a discussion going on our Sharepoint site and I'm trying to paste some JSON for evaluation. I see no [pre] markup or anything similar. Am I just missing it?
1
vote
0answers
67 views

How to prevent SharePoint 2010 Ribbon from reformating HTML code

I have the telerik editor installed in SharePoint 2010 Enterprise, and every time I edit a page in advance HTML mode, I would like SharePoint to remember how I formated the HTML code. But instead, ...
1
vote
2answers
810 views

Display “NaN” instead percentage value

I'm using SharePoint 2007 and developing a custom view using SharePoint Designer 2007. I've a column of a table that should display numbers as percentage. Minimun value is 0, maximum 100. In SP ...
2
votes
1answer
667 views

Remove HTML Tags when Copying and Pasting into SharePoint People Picker textbox

I'm trying to remove formatting and in this case, mailto anchor html tags from being copied when I paste into the people picker textbox/field in SharePoint 2010 and have no idea how to go about doing ...
0
votes
1answer
207 views

Hide Edit button in Data View web part based on Person / Group column

I am working on a customized Project Management solution using SharePoint. I have a data view web part which displays all the project data including Project Name / Project Manager. I have a Edit ...
2
votes
0answers
134 views

InfoPath Designer 2010 - Format HTML tags

I have set up a web browser form for SP2007 in InfoPath Designer 2010. It points to a list that contains several columns of different types, to include some enhanced rich text multiline fields. The ...