Change default views for subfolders
I want to understand how I can change the default views for subfolders in sharepoint online. What I want to accomplish is basically to have the same columns in all folders except for one folder where I want to have completely different columns, by default. I have tried creating content types, added those and connected the view properties to these content types. It works perfectly if I access it manually from the "classic" sharepoint view but not through the regular one which is the one all of my colleagues use and also the one where it needs to work at. I have also tried doing it through the Per-Location View Settings but nothing happens at all when I do that, even when I change the Metadata navigation settings. Does anyone have an idea of how I can fix this?
Unable to show Title column in SharePoint Library
For each file uploaded to a SharePoint Document library (not a list!) that I have created/uploaded I can add a "Title" - however, I am unable to make it show as a column in my library's folders. It does not appear in the show/hide columns within the library although I can see it in the column list when I open the Library settings. "Name" column is available to show/hide, but not the "Title" one. Is this some sort of bug or is there a workaround on how I can showcase the "Title" column within my library? The issue is that I would like to have numeric ID + title in the file "Name", but it would good to showcase only the "Title" (without numeric ID) in SP for better oversight. As an example, the file "Name" would be ABC_Best Document.docx, but I would like to have a column in SP for the file showing the "Title" as only "Best Document". I could of course create another column as "Title" manually, but that would not be the same field then as it is in the Word/Excel info.O365 SharePoint List Column Names Corrupted
While trying to import a list into Power BI, I discovered that most of the column names in one of the lists in one of our SharePoint team sites are corrupted. The display names are intact, it's the internal names that are affected. I've attached a screenshot of what I was seeing in Power BI. Example: This is the URL for what should be the "Location" column. The internal column name is showing up as "uwbz" https://mycompany.sharepoint.com/sitecollection/sitename/_layouts/15/FldEdit.aspx?List=%7BGUIDGUID-G...Field=uwbz My suspicion is that there was some sort of update going on when the list and columns were originally created. Because this is O365 and evergreen by design, we have no real idea when updates are being applied and won't see these issues until we try to do something with them, like import into Power BI or Flow. In this case I re-created the list. That's not something we would want or should have to do... Thoughts, Microsoft?Add Column Using Count
I am trying to add a column named Past12 to my table wynne_incidents. I want to count all the distinct incident_num by employ_id. So basically, I am counting the number of incidents (incident_num) for each employee (employ_id). I have this query which pulls the data correctly. Now I just need to know how to use it with ALTER TABLE and ADD select count(distinct incident_num)as "Past 12", employ_id from wynne_incidents where inc_date >= '04/01/2019' and inc_date <= '06/30/2019' group by employ_id Thank you!
Taking values from certain rows based on data input
So I'm trying to get a value into the column "Cat A Tied" (C column). This value depends on the number in the "# People Tied With" column (D Column). In this case, cell D2 has the number 3 in it. I want the sum of the first three rows of the B column (not including column headers) and then divide that by 3. However, I want the cell to be dynamic so if I change the number to 5 it will then automatically take the sum of the first 5 rows and divide by 5. Additionally, if I put this value into D3, the second row of my table, I'd want the first number (3 or 5, or any number put in) of rows from that same row onwards instead of from the first row of the data set. Any help would be greatly appreciated 🙂
Quick question - single to multi text column type on large dataset
Hi there! Just a quick question; I need to change a column type from "single text" to "multi text" on a SharePoint list that has 60,000 items. I know this is possible to do, the column isn't indexed, and I've done this on smaller lists before. I'm just concerned that this list item count of 60,000 could potentially cause an issue, would this be ok to do? Cheers! Steve.
