User Profile
jmmcdaniel
Brass Contributor
Joined Oct 25, 2023
User Widgets
Recent Discussions
Re: SharePoint Library "show/no show" documents
How about Using Views: In a document library, you can create views that filter out specific documents based on criteria. By setting up a view that excludes the document, users who access that view won't see the document. However, this is not a security measure, as users can change the view or search to find the document. Could you provide more detail about what you are trying to fix or work around?697Views0likes1CommentRe: unable to open Excel file from Sharepoint
Here are some troubleshooting steps for the issue of being unable to open Excel files from SharePoint in Excel desktop: Office Repair: Go to 'Programs and Features' on your PC, select Microsoft Office, and click 'Change'. Choose 'Online Repair'. This fixes most of the Office-related issues. Office Updates: Ensure Excel and other Office applications are updated to the latest version. Updates might contain patches for software conflicts caused by the MS365 update. Clear Cache: Clear the Office cache. This can be found in C:\Users[username]\AppData\Local\Microsoft\Office[version number]\OfficeFileCache. Backup, then delete the content of the folder. Check Permissions: Ensure that users have appropriate permissions on SharePoint. Sometimes, users can view in a browser but not in the desktop due to different permission levels. File Associations: Ensure .xlsx files are associated with Excel desktop. You can check this in the default apps or programs setting of your operating system. Disable Add-ins: Start Excel in Safe Mode (by holding 'Ctrl' while starting Excel) to see if any add-ins are causing the issue. If it works in Safe Mode, disable add-ins one by one to identify the culprit.24KViews1like1CommentRe: Outlook error "Sorry, something went wrong. You may want to try again"
URL Verification: Ensure the Smartsheet URL is correct. Access Rights: Check Smartsheet calendar's sharing settings. Outlook Version: Ensure the user's Outlook is updated. Browser: For Outlook Web, try a different browser or clear cache. Re-publish from Smartsheet: Republish the calendar and use the new URL. Alternative Method: In Outlook, try "Add Calendar" > "From Internet".8.9KViews0likes0CommentsRe: Supporting Key Results that are Integers, especially when the goal is 1.
The issue presented revolves around the intricacies of measuring progress in a binary or achieved/not achieved metric, especially when working with external stakeholders where progress is not linear or predictable. When using Viva Goals or any other OKR tool, the ideal is to have flexibility in defining and measuring Key Results. To address this: Feedback to the Tool Provider: Reach out to Viva Goals' support or product feedback channels. Many companies consider user feedback essential for product development. The more organizations highlight the need for a specific feature, the higher the chance it will get prioritized. Internal Workaround: Create a guideline within your organization that states any Key Results relying on third-party validations, certifications, or similar criteria will remain at 0 until achieved. While this won't prevent someone from putting a decimal value, it sets a clear expectation. Education and Training: Often, the challenges with tools come down to user understanding. Regular training sessions can help clarify the intent behind certain metrics and how they should be updated. Alternative Metrics: Instead of tracking the certification directly, you might consider tracking the internal steps leading up to certification. This way, you can measure progress in a more granular way. For instance, "Complete documentation for certification," "Hold preliminary meeting with auditors," etc. Each of these can be a binary or percentage-based KR leading up to the final certification. Consider Other Tools: If Viva Goals doesn't adapt to your needs over time, it might be worth considering other OKR tools that offer more flexibility in defining and measuring KRs.532Views1like0CommentsRe: Filtering cells onto a new sheet based on values in a column
To achieve this in Excel, you can utilize the FILTER function if you're using a version of Excel that supports it (like Microsoft 365 or Excel 2019 and later). Here's how you can do it: On Sheet2: In cell A1, enter the formula: =FILTER(Sheet1!C:C, Sheet1!A:A="USA") In cell B1, enter the formula: =FILTER(Sheet1!E:E, Sheet1!A:A="USA") These formulas will populate columns A and B on Sheet2 with the names and numbers from Sheet1 where the country is "USA".21KViews1like3Comments
Recent Blog Articles
No content to show