The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [formatting]

The arrangement of data for storage or display.

Filter by
Sorted by
Tagged with
23
votes
4answers
65k 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 ...
9
votes
2answers
38k 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. ...
6
votes
2answers
2k views

JSON Column formatting - Joining values

Is there a different way to join/concatenate values from 2 single line columns into a 3rd column other than the way below? { "$schema": "https://developer.microsoft.com/json-schemas/sp/column-...
5
votes
4answers
4k views

How to make a field appear only when a selection from a drop down list is selected?

I want to make an entry field appear only when a certain selection from the previous drop down list is selected. For example, I want the user to select from (laptops, desktops and scanners). I ...
4
votes
2answers
2k views

Hide “add column” in Sharepoint 2013 List

Is there a way to hide the last column which is always the "add column" (with a little "+" sign in it)? I have changed the "management of content types" to "no". I cannot (do not have access to) use ...
4
votes
1answer
77 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')" }" ...
4
votes
3answers
6k views

Date Only format with BCS

I have created an External Content Type through SharePoint Designer. One of the fields that I'm getting from my database is a DateTime column. In SharePoint, however, I want to format this as a Date ...
3
votes
2answers
3k views

List and change image size

I have created a SharePoint list. Within this list I also added the column "Hyperlink or Picture". In the field settings I selected to format the url as a picture. This works fine. However, now I ...
3
votes
1answer
2k 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 ...
3
votes
1answer
68 views

Conditional Formatting for UK (non-US) dates in custom list

I work in a compliance office and I convinced my boss to start using SharePoint services and part of my job is to build a compliance tracker with dates etc. I found a good solution here and after ...
3
votes
1answer
388 views

sharepoint list view conditional formatting

I'm trying to set a conditional formatting for my custom list data row, it works fine for background color but not for foreground color, when I inspect the element in chrome browser, I found it apply ...
3
votes
1answer
5k views

How do I validate a selected “choice” field in a survey?

We've got SP2010 foundation, and the other limitation is that we do not have access to SPD or any of the programmatic ways of accomplishing this. I'm looking for information about how to set this up ...
3
votes
0answers
92 views

SharePoint 2010 issue - can I create a bullet list that isn't double spaced?

I have some pages being created in SharePoint 2010 (we are migrating to 2016 next year, so skipping 2013 completely). I can copy and paste bullet lists into the page, or create my own, but they all ...
3
votes
1answer
1k 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 ...
3
votes
0answers
266 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 ...
2
votes
2answers
150 views

CQWP ItemStyle: how to display background of description with conditional formatting

I have 3 elements in a field and I would like the CQWP to display red as a bg colour of the field or amber or green. I guess the starting point is <xsl:if test="RAG = 'Red'">background-color: #...
2
votes
2answers
1k views

How to show date as day of week?

It seems like an obvious request, but I could not find an answer. Within a list, how do I show the day of the week for a date? More specifically, how to show day of week for a default value for the ...
2
votes
2answers
15k 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 ...
2
votes
2answers
5k views

Copy/Paste to SP 2010 Page does not keep formatting?

I am trying to copy a formatted Word 2010 document and paste it into a SharePoint 2010 page. Most of the formatting comes over to SharePoint fine, EXCEPT for the indentation of the lines. Is there ...
2
votes
2answers
5k views

Sharepoint 2013 - custom display form - time/date not formatted correctly

I have an issue on my display form with formatting. I have set the language and region correctly - and chosen time and date in a friendly format. When I enter the time and date it all looks fine - but ...
2
votes
2answers
2k views

Format Date using CSR (dd.MM.yyyy)

I´m using SP2013 and i have a Shift Plan which colors the row from TODAY in yellow. var today = new Date(); // zero out the time portion so we will only compare days today.setHours(...
2
votes
1answer
5k views

How to enable bullet styles in Sharepoint 2010?

Intro: I'm running a publishing service using Sharepoint 2010 and recently tried to copy and paste contents from Word 2010 into an article. Problem: After pasting the content, it did not retain the ...
2
votes
2answers
1k views

Is there a way to insert a <blockquote> in a Rich text column?

We have a List in our Sharepoint that we use for reporting quality assurance issues. One of the columns is a 'Description' column which is defined as a Rich text column, is there anyway to insert ...
2
votes
1answer
63 views

Formatting vs. Action Infopath

This might be an easy fix but I can't seem to figure out what's going on with what I'm doing. Below is a picture that I will try to explain: I want to run a formatting rule that when the SC Type is ...
2
votes
1answer
336 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 ...
2
votes
1answer
238 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?
2
votes
1answer
1k 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 ...
2
votes
2answers
4k views

How can I apply custom styles/formatting to an out of the box web part?

I have a list of links stored in a Sharepoint List, and have them displayed in the standard list-item-displaying web part. I would like to have this web part formatted (perhaps with CSS) in a custom ...
2
votes
0answers
601 views

Column formatting changes vertical alignment

I followed this Microsoft guide on column formatting and made the changes I need to get it to work on 3 of my columns. Specifically I am using the bits on "Conditional formatting based on the value in ...
2
votes
1answer
219 views

Adding additional colors to SharePoint

So, I know how to change the theme in SharePoint 2010, I also know how to colors on a calendar. What I would like to know, is there a way to change the calendar colors WITHOUT changing the theme? I ...
2
votes
0answers
46 views

Auto-populate Form Field Based on Selection

I need to be able to type in an invoice number into a form field and have the remainder of the information populate into the form. Can anyone provide me with any code or references on how to do this? ...
2
votes
1answer
678 views

SharePoint Designer 2010 - Conditional Formatting on List

I have been asked to apply conditional formatting to a list in SharePoint 2010 to change the font colour if the difference is 7 or less when you minus the date in the Date Valid column from todays ...
2
votes
1answer
2k views

Change Date Format in SharePoint 2016

I want to change the format of date from MM-DD-YYYY to DD-MM-YYYY in list, Gantt charts etc. I have tried one option so far but it doesn't work properly which is explain below: First option: I have ...
2
votes
3answers
843 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 ...
2
votes
2answers
2k 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 ...
2
votes
1answer
283 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 ...
2
votes
1answer
119 views

SP2010 - Formatted data view web part saved to gallery - get error when dropped on parent site

I have a list on a subsite that I need to feature on the parent site homepage. I created the formatted data view and saved it as a web part in the gallery. I drop it on the homepage but get a "web ...
2
votes
2answers
268 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
3answers
3k views

Column Width in Quick Edit or Datasheet View

Is there a way to adjust the column widths or enable text wrapping in the Quick Edit or Datasheet view in SharePoint 2013? I have seen ways to set widths in the standard list view (using CSS), but ...
1
vote
2answers
2k views

Formatting date inside a If than statement

I am struggling to find an answer on how to format a If then statement in SharePoint 2013 using a calculated column. I need to display the word "Completed" if the date =1/1/1900 or display the date ...
1
vote
1answer
151 views

Sharepoint 2013 - issue with using java script to format columns

I found a few tutorials to do this, many of them point to using the jslink or content editor. I tried following the instructions in this site: CSR code samples #1 (Task Priority color) but it's not ...
1
vote
2answers
2k 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 ...
1
vote
2answers
457 views

Sharepoint2007: Display Document Library Folder contents in customized format?

How can I do a customized view of a Document Library in home page? I want to show like following: ![image][1] **Title of Document** [with link to document] Body of articles [Intro Text] ...
1
vote
1answer
3k views

How to make field text bold in custom edit form?

I am already using custom field iterators to customize the fields on my list forms. When users are creating or editing a list item, I want certain field names to show in bold. For example, when users ...
1
vote
1answer
74 views

Color Coding List Item by Web Part based on value

I am currently trying to get color coding on a list to highlight good medium and bad properties. I have tried to follow the examples shown here for color coding: SharePoint 2013 Client Side Rendering:...
1
vote
2answers
2k 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
2answers
2k 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 ...
1
vote
2answers
600 views

Possible to restrict format/layout/fonts of Wikis & blogs?

Is there a way that I can restrict the text formatting(font etc)/layout on the Sharepoint blog/Wiki sites? Or doesSharepoint have any options to control the HTML that is being generated when users ...
1
vote
2answers
4k 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 ...
1
vote
1answer
2k views

Conditional Formatting - Format row

I'm using SharePoint 2010. In order to implement the "conditional formatting" on my list view, I do so: open my list in sharepoint designer press on the list view press on the "option" tab in the ...