Questions tagged [formatting]

The arrangement of data for storage or display.

Filter by
Sorted by
Tagged with
1
vote
1answer
867 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 ...
2
votes
3answers
987 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

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
1answer
8 views

InfoPath 2010 from dropdown list not showing choices when conditional formatting rule applied

Another "driving me crazy" I add a dropdown list box to my infopath form publishing to SharePoint 2013 list. I add a formatting rule to highlight field. Works fine in preview, when I publish to ...
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
0answers
29 views

Wrap Text not working in SharePoint Excel

Text just appears squished instead of wrapping to the next line. Oddly when I download the file locally the wrapping works perfectly, just in SharePoint does it behave this way.
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
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
836 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
2answers
36 views

HTML to display currency $45700 as $45,700 [closed]

I need to display currency $45700 as $45,700 using HTML.Can anyone please help me here how do I do it.
0
votes
1answer
689 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
75 views

Multi line text field with enhanced rich text is displaying text with an awkward format and extra empty lines are created in the email notification

Please help me in how to correct the format of the text display in the email body. I saw an answer from Ms. Erin L but, I couldn't understand exactly what I should do. Instead of changing the data ...
0
votes
0answers
18 views

How to get items vertically aligned across multiple columns on a modern page?

Given a modern page with three columns, I'd like the following in each column: a little bit of text and a button below it, with both the text and button centered. If each text block has two lines of ...
2
votes
0answers
749 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
40 views

SharePoint List column validation related to another item

I have a SP list with 3 fields: "report type" (choose list "A", "B" or "AB") "Type A due date" "Type B due date". I want to set-up column validation for the due date so that "Type A due date" is ...
0
votes
0answers
20 views

Sharepoint list in Microsoft Edge wont show Backgroundcolor

So I got this weird problem.. in IE and google chrome this works perfectly and all background colours in view formatting works. But when i'm in Microsoft Edge it will only display the background color ...
1
vote
1answer
177 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
45 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
2answers
18k 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 ...
1
vote
1answer
57 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;...
1
vote
1answer
102 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
23 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
22 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
10 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
1answer
317 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 ...
0
votes
0answers
17 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
417 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
74 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
2answers
51 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
41 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
24 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 ...
1
vote
1answer
234 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
46 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 ...
10
votes
2answers
40k 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. ...
0
votes
1answer
35 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
1k 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
377 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
3k 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
1answer
273 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" ...
1
vote
0answers
113 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
123 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
972 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
622 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
509 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
4k 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
52 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
5k 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
368 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
209 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
762 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 ...