Questions tagged [formatting]

The arrangement of data for storage or display.

Filter by
Sorted by
Tagged with
0
votes
0answers
6 views

Formatting list row background color

I am trying to change the background color of rows in my SharePoint (365) list based on values in a column. I am aware you can use additionalRowClass in the JSON formatting pane to alter a row based ...
0
votes
1answer
25 views

Sharepoint 2016: Format hyperlinks in a column

How can I format the hyperlinks of a specific column. In my case I have a list with several columns and one of them with title "Quicklink" is formatted as "Hyperlink" and displays a standard link to ...
0
votes
1answer
23 views

Changing list column width with Script Editor doesn't break line

I have a webpart that has a list with columns. To change the width of these columns I inserted a Script Editor and used this code: <style> .ms-vh-div[displayname='Beschreibung'] { width: 450px;...
0
votes
1answer
23 views

Modify SharePoint List column width of custom webpart with HTML source

I have a custom webpart called Available seminars: I want to modify the width of certain columns. On the Internet it is written that I have to use <style type='text/css'> .ms-vh-div[...
0
votes
1answer
15 views

Date is correct, but String is not being recognized as a valid datetime

I use this to get the current date with one month added to it: var date = new Date(); day = date.getDate(); month = date.getMonth() + 1; month = month + 1; if((String(day)).length == 1) day = '0' ...
1
vote
1answer
20 views

Conditional formatting for a row that contains any information

I have a list that I am using for a library check out. When a person populates the check out date field I want my row to be grayed out. The condition would be if a field contains "any" information. ...
0
votes
1answer
8 views

adding years to existing date to produce expiry date ( SP list)

I have a list of training course that all have different levels of validy. So course A lasts for 3 years Course B lasts for 2 years Course C lasts for 1 year At the moment I have a column with ...
0
votes
0answers
12 views

Strikethrough based on another column

I have a list called Resources that include name and status (Active, Inactive) as well as other information. In another list called Allocations it has a lookup column to the Resources list looking up ...
0
votes
1answer
49 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
31 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
22 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
39 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
117 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
45 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
177 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
30 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
591 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
298 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
1k 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
186 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
1answer
218 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
89 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
103 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
612 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 ...
1
vote
1answer
726 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
414 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
48 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
271 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
178 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
161 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
16 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
2k 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
377 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
611 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
51 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
145 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
59 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
728 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
110 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
30 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
14k 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
672 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
241 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
4k 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
3k 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 ...