Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

The arrangement of data for storage or display.

0
votes
1answer
16 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
28 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
37 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
30 views

Changing date format in CSR (ctx.CurrentItem.Date)

I am using the following script in order to color code the Due Date and the Priority fields. The code works perfectly if my locale is set to English (US), but when I change it to English (UK) or ...
0
votes
1answer
23 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
116 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
13 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
56 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
0answers
5 views

Input data as elapsed time, in mm:ss.0 format into SharePoint 2010

I am using SharePoint 2010 to collect data on a process. We need to capture process elapsed time in the minutes and seconds (mm:ss.0) format, so that we can come up with the average minutes and ...
0
votes
1answer
34 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
128 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
0answers
16 views

SPO color field based on based two column values

I am trying to format a field based on the result from another field in SPO. Currently I have 3 columns: Impact, Safety, Color. The workflow should be as follows: User inputs an impact value (1-6) ...
0
votes
1answer
33 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
21 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
30 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
34 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
21 views

Wrap long file names in Document library table display

I have a problem with long file names in the document library in sharepoint online As it is impossible to format a Name column using JSON column formatting is there any other way to set the display ...
0
votes
0answers
453 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
46 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
3k 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
0answers
242 views

Custom Formatting Modern Lists - Problem using Date Field

I am trying to use the new modern list custom formatting capabilities (in JSON) for an email template (see: https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting#...
0
votes
1answer
23 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
1answer
5k 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
383 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 ...
1
vote
1answer
88 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
1k 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 ...
2
votes
2answers
1k 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 ...
0
votes
0answers
14 views

Block visibility depending on a list value

I have one page - kind of dashboard - where I want to display a block based on one value of a list. In this case i have an Alerts list and I want to pick the one field (status = on/off) in the last ...
1
vote
0answers
21 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
560 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
212 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
36 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
177 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
299 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
555 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
800 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 ...
3
votes
1answer
52 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 ...
1
vote
1answer
791 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
342 views

content search web part (slide show) with black background

I have been trying to find the correct code inside the standard template to modify the content search web part (slide show) background color from black to something else. I do not find anything in ...
1
vote
2answers
2k 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 ...
2
votes
2answers
3k 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 ...
0
votes
1answer
848 views

How to hide Doc Lib toolbar for “New, Upload, Sync, Share”

The goal is to create a Document Library of Document Sets. New Document Sets need auto & unique names, which isn't possible using "New" since it requires a manual filename. As a workaround to the ...
0
votes
1answer
49 views

Formatting Reference Number in 2013 Workflow with Year Part and Leading Zeros

I would like to set a custom reference number for documents in my site library. The format for this reference is Currently IA17-0001. The IA is static, the 17 represents the year, and 0001 ...
1
vote
1answer
204 views

Use Javascript to change Title Column Color based on Drop-Down Selection

I have an announcement list slider (using the Hillbilly slider set up.) I've added a heading section that pulls the Title field of the announcement list. I would like to add some Javascript that ...
2
votes
0answers
39 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? ...
1
vote
2answers
972 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
115 views

Date format without spaces

we have migrated Sharepoint from Windows Server 2008 R2 to 2012 R2. Previously was date format without spaces (f.e. 4.1.2017), now it has to be with spaces When I delete spaces, it write text like ...
1
vote
1answer
508 views

What is rich text formatting?

The formatting options for a multi-line text field in SharePoint Online are plain text, rich text and enhanced rich text. For some reason rich text isn't available when you first create a column. ...
0
votes
1answer
63 views

Disable Form Field Unless [duplicate]

Within my SharePoint 2013 form I have a field labeled "Type of Outage" which has different six different choices. Further down the form I have fields labeled "day of the week" and "week #". These ...
1
vote
0answers
258 views

Add colored border to some elements of table

I would like to know if it is possible to add a border of a specific color in a table. The preset styles do not work as I keep some of the table boxes clear, and some colored and only want the border ...