Conditional Formatting on whole column with variable reference cells
Hi, I'd like to format the colour fill of multiple cells within one particular column, when it's value is less than a cell in the row above of the next column. how should I do this please? eg. when the value of D93 is smaller than the value of E92 format fill red. Apply to all D's. So far I have established that if I type =($D$93<$E$92) then I can make the rule work for cell D93. But how can I replicate this formula throughout the whole of the D column, without typing for each individual cell. Is this even possible? Is there a short cut to copying the rules over? Thankyou 🙂JSON Clickable Action and sp-field-quickActions
Hi, I'm trying to format a quickfield action to open a task view link. Everything works as intended but I can't format the icon; the most it does is change to red when using the sp-field-trending--down class but if I use the sp-field-quickActions, it simply ignores it and displays as a regular ugly blue/purple hyperlink. I want to use a red or blue color (no ugly underline and make it a little bit bigger), any help would be greatly appreciated. Here's the code: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "debugMode": true, "elmType": "div", "children": [ { "elmType": "span", "style": { "padding-right": "8px" }, "txtContent": "[$ID]" }, { "elmType": "a", "attributes": { "iconName": "=if([$Tasks_x0020_List] > 0,'TaskLogo', '')", "class": "sp-field-quickActions", "target": "_blank", "href": { "operator": "+", "operands": [ "https://-----.sharepoint.com/eQMS/Lists/Customer%20Complaints%20Tasks/AllItems.aspx#InplviewHash2000000e63d8bd3fdec=FilterField1%3DComplaint%255Fx0020%255FID-FilterValue1%3D", "[$ID]" ] } } } ] } Here's the result:
SharePoint 2019, column formatting not working
Environment: SharePoint 2019. I am trying with column formatting. It is working fine with Online. Same code is not working in SP2019. May be office fabric is not loading as expected in SP2019. Is there any option to make it enable ? When i see in console, it is giving following errors:
SharePoint List Web Part - Column Formatting Links
This post is meant to address why the column formatting for "target": "_blank" doesn't work in the SharePoint list web part. I have a SharePoint lists which has the Title column formatted to open a link. The JSON is set to open the link in a new tab. This functionality works when viewing the list itself, but when I put it on a page using a List Web Part, the link opens in the same tab. The real problem is when the link doesn't open in a new tab, after SharePoint navigates, the quick launch isn't updating to the subsite's navigation. I've seen posts on this specific issue before as well. The partial page loading/caching must be causing this. The two issues are somewhat unrelated. { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "a", "txtContent": "@currentField", "attributes": { "target": "_blank", "href": "='[MySiteUrl]/sites/ops/[mySubSiteName]' + [$ID] + '/SitePages/Home.aspx'" } }Date of release of Column formatting in SP Online Modern experience
Hello, Have received a mail about a new feature : Column Formatting on modern experience Lists. But I see nothing in my First Release Tenant. Did I look at the good place ? If I'm good, do you have a date for this feature ? I saw that custom forms with PowerApps was delayed, perhaps the same ? ThanksRemoval of special characters in a cell in Modern SharePoint Library
Hi Everyone, So I have a document library where the customer wanted to manually create indented subtasks. To do this, they added 5 dashes to specific items to create the appearance of indention. They want these dashes removed, while maintaining an indention. This is what it looks like: The Title column is just a single-line text column. I want the bottom three entries (that have the dashes) to appear indented under the top entry. But I obviously don't want the dashes. I don't know if this is a JSON issue, or may a power automate workflow to get rid of the dashes. Can I change the font of the dashes to white? I'm just not sure. Any help would be greatly appreciated. Thanks! Chris
