SharePoint List calculated column formula using a Lookup column reference
Given: A SharePoint List (SPL) called Contractors with the following columns: ContractorID // Display name of the default ID column ContractorName Another SPL called Reports with the following columns: ReportID // Display name of the default ID column ReportNumber // Calculated column Contractor_ID // Lookup column referring to the ContractorID column of the Contractors SPL The calculated column, ReportNumber, would have a formula similar to: = [ReportID] & "-" & Contractor_ID Question: Does SharePoint Lists support the use of a Lookup column in the formula of a calculated column? If so, I need help on the proper syntax for the formula. (The formula above is not working) Thanks in AdvanceForce Office Files to Open in Desktop App (via link, from web parts.. in all cases)
I want to force Office files stored in SharePoint to open in the desktop app - NEVER in Office Online apps. I have configured the site and the Document Library but opening in the native app only seems to work when navigating to the file in the DL and clicking it directly. Web Parts seem to always open the web app, as do links copied via the "Share" or "Copy Link" options in the DL. I've made up quick video to show and tell: https://youtu.be/SvJd2_TLsmw Note - while I was making the video, I stumbled upon a workaround for when we share links internally via e-mail (and maybe I can use the same workaround when sending files in Teams.) I also fumble through trying to explain what I've been toying with as far as other workarounds.. the limitations of my technical capabilities will be apparent! I already looked at several other posts, e.g.: https://techcommunity.microsoft.com/t5/SharePoint/Creating-a-shareable-document-link-that-forces-a-document-to/m-p/296647#M24291
AutoNumbering Columns in SharePoint List
Good morning, I have a Sharepoint list used for tracking my documents. I manually number each document, but this has become challenging over the past month. Is there a way to automatically create a unique ID? I need something that starts with the two-digit year and has the document number created that year. for example, 22-205 22 for the two-digit year 205 for the document added that year. The number will also need to be reset every year. Once January first, 2023 comes, the following document created will be 23-001. Can someone assist me?Sharepoint Files is on Read Only Mode when opened with Office Desktop
Hello SharePoint Community, Just wanted to know if you encountered similar issue wherein any Sharepoint files are on Read Only mode when opened with Office Desktop. 2 Tenants so far are affected. It was working before but 2 weeks ago is when the issue started. Test made so far: - No issue when accessing online - Found out that the affected users are using a different version of Office apps which consist of Pro Plus 2016 and Home and Business 2019 - Non-affected users were using Apps for Business version ( case for both tenants) - Had to switch the version of the affected users to Apps for Business to fix the issue Ask: - cannot find any documentation if there is a recent update that caused this issue for non-365 office version installed. Any insights is appreciated. Thank you
unable to open Excel file from Sharepoint
"Hello, I am experiencing issues with certain users unable to open files from SharePoint in Excel desktop, although they can do so in the browser. Accessing files from local drives or OneDrive is functioning correctly. This problem is affecting multiple SharePoint instances and arose after the MS365 update. The error message 'You can't open this file' appears. Can anyone assist me in resolving this issue? Thank youHow to hide "New item" title on SharePoint List Form?
Hi there, I have a SharePoint List with a PowerApps customized list form, however when viewing the app on SharePoint full screen (via NewForm.aspx), it shows this annoying 'New item' title, that I can't seem to figure out how to remove. There doesn't seem to be any settings, and I opened the site in File Explorer and looked at the NewForm.aspx file and couldn't find the title in the code. Any help?
SharePoint Mobile App (iOS and Android) won't open 'link' content types from a document library
I have a client occasionally creating 'links' (URL) within their SPO document libraries with the 'Links' content type. These links open as expected from a desktop browser. They will not open when browsing to it from the SP mobile app. I apologize if this is a duplicate entry but I've been searching online fruitlessly. Cheers!
