Questions tagged [formatting]

The arrangement of data for storage or display.

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

SharePoint 2013 - format webpart list column text not based on a condition

I would like to change the color and text size of a calculated column in a SharePoint 2013 not based on any condition. Searching online I have only been able to to find ways of applying conditional ...
0
votes
1answer
88 views

Column Formatting Option not available

I can't see an option for format column where I can enter JSON codes.
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 ...
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 ...
0
votes
2answers
33 views

Custom List Header Column Sort/Filter

I'm trying to re-format the sort/filter drop down box on the column header of a custom list (font-family, font-size, background etc). This appears to be possible by using the following rule in a ...
0
votes
0answers
19 views

Modern view - List - Formatting the Like “button”

I am trying to do something that I thought was simple but I am getting lots of difficulty finding my way... I spent more than a week looking for that info now :( I want to customize two columns in ...
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 ...
0
votes
1answer
13 views

No Column formating template

I am trying to add a column format template , basically marking the column “red” when the column is set to “No” and “blue” for when it is “Yes”. My custom columns, they don’t have the option to ...
2
votes
1answer
666 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 ...
1
vote
1answer
57 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:...
0
votes
2answers
11k views

Change column width in SharePoint 365, using JSON

I have a several lists containing columns with multiple lines of text. The standard column width is too narrow. I'd like to increase the width using the new column formatting functionality. I've never ...
0
votes
1answer
40 views

Conditional Formatting based on whether or not time is present

Is there a way to set background color conditionally ony when data is present? Only when someone sets a time due it shows up in the column and I want to make that more visible. I am familiar with ...
1
vote
1answer
1k views

SharePoint Conditional Formatting Date Column

I've been trying to create a Conditional Color column for dates that are expired. The expired dates should be red and the dates that are not should be clear. I tried to use the code from http://www....
0
votes
1answer
55 views

Reference Metadata field with JSON Formatting

I am unable to capture the Managed Metadata field within my JSON formatting. I can reference other fields by their Internal names but how would I go about grabbing that MMD value? { "elmType": "a", ...
9
votes
2answers
37k 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-...
0
votes
1answer
26 views

Hide items in list based on group membership

I have a list of items in Sharepoint. I want to allow group members to submit items to the list, but I only want owners to be able to view the items. Microsoft has an example of hiding fields in rows ...
0
votes
1answer
174 views

How can you edit the format of modern style list/library column headers in Sharepoint Online?

Is there a way to format the column headers of a modern list or library in Sharepoint Online? I would like to make the dividing borders between column headers show up even when you're not hovering ...
0
votes
1answer
183 views

Column Formatting using JSON: Get value of the column “_ModerationStatus”

I'm trying to check the value of the column _ModerationStatus in a document library with that has content approval. I have the following JSON: { "$schema": "https://developer.microsoft.com/...
1
vote
1answer
309 views

Using modern list view formatting to alternate row colors

I have been looking into using view formatting to alternate the colors of rows in order to recreate what came out of the box in the classic views. However it seems like I can't access the row ID as a ...
0
votes
1answer
488 views

Column formatting changes not saving

For my document library on sharepoint online modern view, I have a column for Title. I've tried to format it so that the height changes dynamically based on how long the title is and when I save it at ...
0
votes
1answer
398 views

Formatting list row based on status column Office365

I am trying to change the background color of each row in SharePoint list on office 365. I have been looking online for two days there are so many solutions and most of them don't work on new list ...
0
votes
3answers
142 views

Format text on lookup popup and text inside a table

I have a multiple lookup data inside a table. I have to format a text "Stato" with green background if it is "PRONTO CONSEGNA". And do the same thing inside the table isolating the single "Id_uni" ...
0
votes
0answers
134 views

List View Row Formatting Using Ratings Column

I have a SharePoint Online list that contains the standard like style ratings feature. I am trying to format a row view for this list, I can get everything to work except for the ratings column (I ...
1
vote
0answers
47 views

Column formatting for multi-choice field in SP Modern

Context: I'm working as a regular user consuming my company's modern Sharepoint deployment, so my capabilities are pretty limited other than what's available from the GUI. I'm trying to format a ...
4
votes
1answer
75 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')" }" ...
1
vote
1answer
443 views

SharePoint Online - Conditional formatting using JSON

I have a Hyperlink column in my list which I want to apply some custom formatting. the column is not Required, meaning the field might be blank on some rows. How can I check if the field is blank, ...
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 ...
0
votes
1answer
301 views

Using JSON data bars Column formatting for text (stages)

I am looking at using column formatting to allow us to easily identify which stage a project is in. In SharePoint online using modern views. We have 4 stages and would like to have a 25%, 50% 75%, ...
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 ...
0
votes
1answer
45 views

Modern Page - Display Powershell Code with corrent visual format

is there a way to display powershell code in a code block with the correct visual elements to it (colour, font, etc)? We are moving to modern pages for our internal how to guides and this would help ...
0
votes
1answer
4k 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
2answers
189 views

Change the background colour of a cell - not highlighting text

I'm using the script editor to format my list. When I use this block of code: function boldTemplate(ctx){ var value = ctx.CurrentItem[ctx.CurrentFieldSchema.Name]; switch(value){ case ...
1
vote
1answer
140 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 ...
0
votes
0answers
670 views

Formatting column making the column text to disappear in latest Sharepoint online

Formatting column with JSON makes the column text to disappear in latest Sharepoint online. E.g. if I try to use something like that: { "elmType": "div", "txtContent": "@currentField" } saddenly I ...
0
votes
1answer
35 views

Color coding a single cell in list with jquery

based on this jquery that worked, how do I change it to color code a single cell instead of the whole row? I also need 3 colors <script type="text/javascript"> $(document).ready(function(){ ...
2
votes
2answers
148 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: #...
0
votes
1answer
15 views

How can I change the format of a Combo-Box with fill-in answers?

I'm trying to create a field with InfoPath 2013 that is a list box that allows a user to enter in their own values. That part is simple. Where I'm running into issue is that I want to change the ...
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 ...
0
votes
1answer
213 views

How to force a number field to keep zeros at the start?

I would like to use a number field to add phone number to a Sharepoint list. But if the phone number starts with 0, it is automaticly removed by default. Is there any way to keep it? I didn't want to ...
0
votes
1answer
44 views

Web Part alignment query

How do I align the content editor web part in the right column to match the same height as the script editor web part in the left column? I've tried fixed sizes in the web part properties but that ...
0
votes
0answers
24 views

Conditaionl Formating of row when field is not displayed

Seems simple, but I cant figure it out. I want to highlight a row based on text being entered in a field, but the field is NOT displayed. It shows up the way I want if the field is showing up in the ...
0
votes
1answer
101 views

Sharepoint Conditional Formatting or Add Flag?

OK, so I'm trying to basically add an indicator of any kind in one field based on another field having data entered v no data entered. Ideally would like to display a red flag, or some kind of icon, ...
0
votes
1answer
46 views

What causes the page jumping when applying formatting?

SharePoint 2013 on premises, IE11, publishing site web page editing. Applying formatting (anything like bold, colour, links) causes the page to immediately scroll (jump) the highlighted text to the ...
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 ...
0
votes
1answer
95 views

Highlight row based on indent level not using SharePoint Designer

I would like to have a conditional formatting of the rows in my SharePoint task list table. The table contains (parent) tasks and sub-tasks. As an example, I would like to shade the parent tasks grey ...
1
vote
1answer
4k views

Column Formatting using JSON (Sharepoint Online)

I'm trying to inject some life into an old Sharepoint site (classic) by creating a new Progress Bar based on a %Complete field. The new JSON template code provided by Microsoft doesnt seem to want to ...
0
votes
1answer
26 views

Prevent Default Page Format From Appearing

I have several Sharepoint 2013 pages to which I've applied .css styles. But whenever the pages load, the default format flashes on the screen before my .css is applied. Does anyone have a script ...
2
votes
0answers
586 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
211 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 ...