Questions tagged [formatting]

The arrangement of data for storage or display.

Filter by
Sorted by
Tagged with
0
votes
1answer
26 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
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 ...
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 ...
0
votes
2answers
32 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 ...
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
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 ...
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", ...
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
88 views

Column Formatting Option not available

I can't see an option for format column where I can enter JSON codes.
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/...
0
votes
1answer
396 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
133 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
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 ...
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-...
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, ...
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%, ...
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
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
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
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
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 ...
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
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 ...
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 ...
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 ...
1
vote
2answers
2k views

SPO Conditional Formatting - Color Column views

I have 2 columns namely: "Status", Choice column with Red,Yellow,Green as values "Comment", Multiple Lines of text column Now, I want to set the background of "Comment" column using the color ...
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 ...
1
vote
0answers
22 views

Cell values looks different to others on SharePoint

I have an excel sheet stored on SharePoint. It has a table in it. The cells of this table get a value based on a formula I run on another PIVOT table. The formula returns the value as either P or ...
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 ...
1
vote
1answer
308 views

SharePoint 2013 Content Query Tool Part - How to format a “Date and Time” display field?

In the Content Query Tool, I'm pulling data from a task list, and for the Description, I want to display the Due Date. In the list itself, the Due Date is set to Date Only, Friendly Display Format (ex....
1
vote
1answer
42 views

Viewing PS1 files in browser: Possible in SPO 'classic mode'?

Not a huge fan of the new fangled site layout for newly created SharePoint Online sites, but it is growing on me. One feature I particularly like is the ability to view PowerShell files, complete with ...
0
votes
1answer
222 views

Content Search web part costomization: remove the document icon from the 2 lines

I have removed the document icon but the line looks 'indented', does anybody know what code I need to touch to have the text in line with the box border on the left? I would like a code that can be ...
1
vote
1answer
415 views

Conditional formatting on list script

I used the above code to apply a background color on a line with the word High in a field (choice). It does not work. I have used a code that matches exactly the word as in other fields (descriptions ...
0
votes
2answers
933 views

Conditional formatting in item view (display form) using CSR / JS / CSS - is it doable?

Is it possible to apply conditional formatting to an item view [Display-Form] just like in the list? I use SharePoint Online, Cisar and SharePoint extensions for Chrome.
0
votes
2answers
1k views

How to format a currency field in SharePoint 2013

I have a currency field in one of my SharePoint 2013 lists...How do I automatically format the field. Example: If the user enters 30000 it should automatically format to 30,000 and if he enters ...