Format QuickPart as Currency
Hi, I am currently passing a currency value from Sharepoint to a word document through quick parts. The value is a currency everywhere except for on the document. I found this on web https://social.msdn.microsoft.com/Forums/office/en-US/de2272f1-0c03-43a4-8bc9-78917cc5992d/format-quick-part-document-property-received-from-sharepoint but its from 12 years ago. I used ctrl-F9 to insert a pair of field code braces { } and then { QUOTE "[QuickPart]" \#$,0.00 }. Does anyone have any suggestions? I really don't want to store the number as text in sharepoint for analytics reasons but the user I'm building it for really needs it displayed correctly on the document.
Yet Another Conditional Formatting Query
Hey folks, I have an SP list with 3 relevant columns - IssueDate, ReviewFrequency, and NextReview. IssueDate is for manual date entry, ReviewFrequency is a choice of N/A, 3, 6, 12, 24, 36. NextReview is a calculated column that adds number value in ReviewFrequency to IssueDate. I have applied JSON formatting in Format View to format rows where NextReview is less than today (@now) in sp-field-severity--severeWarning, rows where next review is due within 30 days (2592000000ms) in sp-field-severity--Warning, and all other rows in alternating sp-css-backgroundColor-BgLightGray30 and sp-css-backgroundColor-noFill (giving zebra alternate banding). All works well apart from an issue with dates being read by conditional formatting as MM-dd-yyyy not dd-MM-yyyy as illustrated here: How do i ensure dates in the columns are seen / interpreted as dd-MM-yyyy in the conditional formatting rules? Thanks in advance,How to Detect Files of the Same Size on your Computer via PowerShell
Learn how to use PowerShell to detect files of the same size on your computer quickly and easily. This article provides a script to automate the process and save storage space. Follow the step-by-step instructions and improve your file management skills with PowerShell automation.
