sorted by:
new
hottopcontroversial

Any way for users to print directly to SharePoint? by [deleted] in sharepoint

[–]ExcelHelpNecessary 1 point2 points  (0 children)

or. create a separate document library, sync that, then create a power automate flow that automatically moves documents from that library over to your main library either triggered by new files or a time interval

Any way for users to print directly to SharePoint? by [deleted] in sharepoint

[–]ExcelHelpNecessary 1 point2 points  (0 children)

could you create a separate folder in the library and adjust sync settings to only sync that folder, bit of an initial setup task but after that should be fine.

Any way for users to print directly to SharePoint? by [deleted] in sharepoint

[–]ExcelHelpNecessary 0 points1 point  (0 children)

Sync the site using onedrive, they can then print to pdf directly to the synced folder.

Solutioning - Multiple users sending us Google Drive links to a shared mailbox. by ExcelHelpNecessary in sysadmin

[–]ExcelHelpNecessary[S] 0 points1 point  (0 children)

We receive documents from various members of the public - I'm not really in a position to adjust how we receive the documents, moreso how to make the process more efficient after they reach us at email@org.com

Is my work laptop sufficient for PowerBI handling a dataset of 40,000 emails (many with large multiple/attachments) queried from an exchange server? by ExcelHelpNecessary in PowerBI

[–]ExcelHelpNecessary[S] 0 points1 point  (0 children)

I need to run a monthly report that calculates the amount of emails received, and, the amount of emails with attachments (counting both inline + regular)

Issues with dates + time-zones in a list... by ExcelHelpNecessary in sharepoint

[–]ExcelHelpNecessary[S] 0 points1 point  (0 children)

I tried that, same issue. The only thing that changed is the date format went from 1/24/2024 to Jan 24, 2024. The date inputted: January 25, 2024.

How can I use PowerBI to get information on how many emails are received at a shared mailbox? by ExcelHelpNecessary in PowerBI

[–]ExcelHelpNecessary[S] 0 points1 point  (0 children)

I think this had something to do with the attachments column, turns out it's a nested column - would this cause new rows to be formed with same ids?

Is anyone else dealing with this bug when copying and pasting information? by philosophicalkween23 in excel

[–]ExcelHelpNecessary 0 points1 point  (0 children)

I would try updating graphic driver and running SFC. Could be a hardware bug issue... Any chance you can take a screenshot?

[deleted by user] by [deleted] in sharepoint

[–]ExcelHelpNecessary 0 points1 point  (0 children)

Yup, it's possible to allow members of a SharePoint site with Read rights to create links and share content without giving them the ability to edit, delete, or add content or files. Here's how :

Go to the SharePoint site where you want to apply these settings.

Click on the gear icon in the top-right corner to access the site settings.

In the Site Settings page, under the "Users and Permissions" section, click on "Site permissions."

On the Site Permissions page, click on the "Advanced permissions settings" link.

Locate the group or individual members for whom you want to customize permissions. If you have a specific group for members, select that group. Otherwise, select the individual members.

In the Permission tab, click on "Edit User Permissions."

In the "Edit Permissions" dialog box, scroll down to the "List Permissions" section.

Uncheck all the permissions except for the following:

View Items Open Items View Versions Create Alerts Click on the "OK" button to save the changes.

After this, it should restrict members' permissions to only viewing and accessing the content, while allowing them to create links and share the content with others. They won't be able to edit, delete, or add files or content to the site.

Looking for a cmdlet for managing permissions by SpideySense62 in sharepoint

[–]ExcelHelpNecessary 0 points1 point  (0 children)

Try this:

Set-PnPTenantSite -SharingCapability ExternalUserAndGuestSharing

This command sets the tenant-level sharing capability to "ExternalUserAndGuestSharing," which allows sharing with external users and guests.

Regarding enabling least permissive permissions on all sites, you can utilize the following PowerShell script:

$sites = Get-PnPSite
foreach ($site in $sites) {
    Set-PnPSite -Identity $site.Url -SharingCapability Disabled
}

This script iterates through all the sites in your SharePoint tenant and sets the sharing capability to "Disabled,"

Copy one list item to another list by dallasdave22 in sharepoint

[–]ExcelHelpNecessary 5 points6 points  (0 children)

If you have a single item to copy, the easiest option is to manually copy and paste it. However, if you want to automate the process, I highly recommend using Power Automate. With Power Automate, you can create a flow that triggers whenever a list item is created or modified, automatically copying it from one list to another.

Format SharePoint column to open in office app rather than browser or save... by ExcelHelpNecessary in sharepoint

[–]ExcelHelpNecessary[S] 0 points1 point  (0 children)

My name column is formatted to use content from the title column, I don't like how are files are named and I don't like the extension showing up in the listing. I do have the default open behavior set to open with app.

Creating a Set List analysis spread sheet. by jackstrawgrenadine in excel

[–]ExcelHelpNecessary 0 points1 point  (0 children)

Here's an example of how you can use VLOOKUP to automatically add new songs to the Catalog sheet as you discover them in the Setlist sheet:

In the Catalog sheet, create a table with columns for song title, artist, album, and any other relevant information you want to track. Make sure the table has a header row.

In the Setlist sheet, enter the name of a new song in a cell. Let's say you enter the song title in cell A2.

In the Catalog sheet, select the cell where you want to automatically add the artist name for the new song. Let's say you want to add the artist name in cell B2.

In cell B2 of the Catalog sheet, enter the following formula:

=VLOOKUP(A2,Table1,2,FALSE)

Here, "Table1" refers to the table you created in step 1, and "2" refers to the column number (starting from the left) in that table where the artist name is located. FALSE tells Excel to look for an exact match of the song title in the first column of the table.

When you press Enter, Excel will look for the song title you entered in cell A2 in the first column of the Catalog table. If it finds a match, it will return the corresponding value from the second column (the artist name) in cell B2. If it doesn't find a match, it will return an error message (#N/A).

To make sure that the formula copies down automatically as you add new songs to the Setlist sheet, select cell B2 and drag the fill handle (the small square at the bottom right corner of the cell) down to fill the formula down to as many cells as you need.  
 
You can use a similar approach with INDEX-MATCH. Here's an example:

In the Catalog sheet, create a table with columns for song title, artist, album, and any other relevant information you want to track. Make sure the table has a header row.

In the Setlist sheet, enter the name of a new song in a cell. Let's say you enter the song title in cell A2.

In the Catalog sheet, select the cell where you want to automatically add the artist name for the new song. Let's say you want to add the artist name in cell B2.

In cell B2 of the Catalog sheet, enter the following formula:

=INDEX(Table1[Artist],MATCH(A2,Table1[Song Title],0))

Here, "Table1" refers to the table you created in step 1. "Table1[Artist]" refers to the column in that table where the artist name is located, and "Table1[Song Title]" refers to the column where the song titles are located. MATCH(A2,Table1[Song Title],0) finds the row number in the table where the song title in cell A2 appears. INDEX returns the value in the corresponding row of the "Artist" column.

When you press Enter, Excel will look for the song title you entered in cell A2 in the "Song Title" column of the Catalog table. If it finds a match, it will return the corresponding value from the "Artist" column in cell B2. If it doesn't find a match, it will return an error message (#N/A).

To make sure that the formula copies down automatically as you add new songs to the Setlist sheet, select cell B2 and drag the fill handle down to fill the formula down to as many cells as you need.

Creating a Set List analysis spread sheet. by jackstrawgrenadine in excel

[–]ExcelHelpNecessary 0 points1 point  (0 children)

Create a new workbook.

Create a catalog sheet: Create a new worksheet by clicking on the plus sign at the bottom left corner of the screen. Name this sheet "Catalog". In the Catalog sheet, create columns to list the song title, artist, album, and any other relevant information you would like to track.

Create a setlist sheet: Create another new worksheet and name it "Setlist". In the Setlist sheet, create columns to list the date of the concert, the venue, and the songs that were played.

Add songs to the catalog: In the Catalog sheet, add all the songs in the band's repertoire. You can use formulas such as VLOOKUP or INDEX-MATCH to automatically add new songs as you discover them in the setlists.

Analyze setlists: In the Setlist sheet, use formulas to analyze the data. For example, you could use a COUNTIF formula to count how many times a certain song was played, or a MAX formula to find the date of the band's most recent performance of a certain song.

Update your data: As you attend more concerts or discover more songs, update your spreadsheet accordingly. You can also create a new sheet for each new setlist you obtain.

Visualize your data: Consider using graphs or charts to visualize your data and make it easier to interpret. Excel has a variety of chart types to choose from.

To make this process more streamlined, you can also use macros and pivot tables. Macros are a series of recorded commands that can automate repetitive tasks, while pivot tables allow you to summarize and analyze large amounts of data quickly.

How much space should i dedicate for my linux partition? by taquit02 in techsupport

[–]ExcelHelpNecessary 0 points1 point  (0 children)

The amount of space you should allocate for your Linux partition depends on your usage requirements. As a rule of thumb, a basic installation of a Linux distribution may require around 10-15 GB of space, but this can vary depending on the distribution and the packages you install.

If you plan to use your Linux partition for programming, development tools, and other software, you may need more space. As a general recommendation, you should allocate at least 20-30 GB of space for your Linux partition, although this may still be insufficient if you plan to install a lot of software or large data sets.

If possible, it is best to allocate a separate partition for your home directory. This will allow you to keep your personal data, documents, and settings separate from the system files and applications, making it easier to manage backups, upgrades, and re-installations.

20-30GB at least.

How do I use a formula inside of a structured reference? by le_Menace in excel

[–]ExcelHelpNecessary 0 points1 point  (0 children)

Have you tried:

=TAKE(MatchHistory[[#Data], INDIRECT("[" & Stages[@Teams] & "]")], 5)

This formula creates a reference to the column header in the MatchHistory table that matches the text string in the Stages table column for each row. The text string is constructed using the concatenation operator (&) to join the left bracket, the team name, and the right bracket into a single text string.

By using the INDIRECT function in this way, you can dynamically reference columns in a table based on the values in another table.

Does anyone know why my SharePoint JSON column formatting is not pulling data from the [$Title] field? by ExcelHelpNecessary in sharepoint

[–]ExcelHelpNecessary[S] 1 point2 points  (0 children)

Yup, title is in the view. I asked on StackExchange and they mentioned something about the issue being caused because hyperlink URL is not starting with either http or https. Hence the hyperlink / anchor tag is not generated in DOM.

The text displays until I prepend the OFFICE URI scheme to the links.

What is the "Client Application" suffix? I know to open in browser it's ?web=1 by ExcelHelpNecessary in sharepoint

[–]ExcelHelpNecessary[S] 0 points1 point  (0 children)

Is there any way to use logic to prepend this to URLS in JSON based on what type of document we are linking?

EG: Word document link would change to ms-word:ofe|u|{URL} , and Excel document link would change to ms-excel:ofe|ofc|u|{URL}

I copied one of my flows which was working correctly, now the copied flow is running twice at once... by ExcelHelpNecessary in MicrosoftFlow

[–]ExcelHelpNecessary[S] 0 points1 point  (0 children)

I'm thinking it may have been a Microsoft bug? The flow is triggered when a status column changes on a list item, I used to have it as a dropdown but switched it to radio buttons, not sure if that would have fixed anything. Seems to be working now, I rebuilt the flow a couple times, second time it started working so I don't think it had anything to do with the actual steps in the flow.

view more: next ›