SharePoint List Calendar View Conditional Formatting Not Displaying for Everyone
Good afternoon, I have an odd issue I'm struggling with. I've implemented some JSON code that changes the color of a Sharepoint calendar view event based on the event type. Most people see the color coding, however some people see all event types as one color (red). At first I thought it had to do with the level of MS access each user had (the first to flag it was an outside consultant), but a few others also experience this issue and their access levels range from Associate through Director. Has anyone else experienced this issue and know how to fix it? Thank you.
Conditional formatting for decimals
Hello Experts, I am creating an excel sheet where user will have to put values with 4 decimal places. The value will turn red if it does not have four decimal places (i.e. more or less decimals places). I formatted the cells as number with four decimals and red font, so all input values become red (regardless of decimals places). Then, I applied the conditional formatting with formula =LEN($D6&"")-FIND(".",$D6&"")=4, and conditional formatted the font black, so all input values with four decimals turn black. Everything works fine till this stage. I have an issue while I put value with four decimals places, but zero at fourth decimal place (e.g. 1.1110). The excel doesn't consider trailing zero at a decimal, and doesn't convert the value to black. I am sure I am missing something here. Your support will be highly appreciated. Thanks in advance!!
Formulas to highlight cells
Hello! Thank you so much in advance for your help! I have a cell in A1 that contains: Composer A (BMI) 50% [292650159], Composer B (ASCAP) 30% [154541151], Composer C (SESAC) 10% [55547898], Composer D (SESAC) 5% [4125475], Composer E (SOCAN) 5% [02124054] 1) I'd need a formula to use in Conditional Formatting that will turn this cell green if the sum of the % equals 100%. 2) I'd need another formula to turn the cell red if the sum doesn't equal 100%, and no highlighting if the cell is empty. *** I have another cell in B1 that contains: Publisher A (BMI) 50% [612559885], Publisher B (ASCAP) 35% [02135474], Publisher C (SESAC) 15% [01023545] I'd need a formula to highlight the cell in green if the percentages for BMI and SESAC match the ones in the previous cell (A1) for composers and if the sum of all the % in this publisher cell equals 100% (SOCAN composers go under the ASCAP publisher in this example that's why there is no Publisher for SOCAN). The cell should be red if there is an issue with the % splits. I really appreciate your help! Thanks again!Conditional Formatting in Sharepoint List based on hidden column items
Hi all, I'm facing the following issue and don't still couldn't find any solution: I made a conditional formatting of the lists-lines based on items on the column "A" now I want to hide the column "A". After it, the conditional formatting doesn't work. It works only if the column isn't hidden. Do you know the way I can hide the column and the formatting works? Thank you in advance! Best regards Dimitrij
Conditional formatting - only show button if attachments are present
Hi, I am trying to only show a button in a column, if there is an attachment present in the same row on the attachment column. Here is what I have so far: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "button", "txtContent": "Send Offer", "customRowAction": { "action": "executeFlow", "actionParams": "{\"id\": \"f191e7c8-1a36-4553-9d64-607764fc6f83\"}" }, "style": { "background-color": "blue", "color": "white", "visibility": "=if(([$Attachments] == false),'visible','hidden')" } } I have tried changing " [$Attachments] == false) " to equals true, 1 and 0, and there's still no use. If I look into the address bar I can see " FilterField1=Attachments&FilterValue1=1 ", but even when I enter "1" as the value the button still does not display when attachments are present. Any help is highly appreciated. Thank you!Using Power Automate to create a new item in SharePoint if the total Qty is not matched.
How can I create a flow in Power Automate or use conditional formatting in SharePoint to create a new item/separate line if the result in one column, "approved or shipped Qty" does not match the original input of "requested Qty". So the balance of what was not approved/shipped is then input into a new line/ new row as its own requested qty. Thank you.
