Need Help
4 TopicsAdded choices in Sharepoint Lists disappear when a different choice value is used in a view
I have set up a Lists that uses alot of Choice rows to utilize its search bar for manually added or past inputted responses. One of the choices set a line as "Open", "In progress", or "Closed". The closed status is attached to a viewing that hides the closed ones. However for some odd reason this hides the past added values from being searched up in all the other choice lines. Why does this happen? It is ruining one of the features that we are using, the ability to search up and click on past values added to that row.2.3KViews0likes3CommentsSharePoint List - Create ID # without filling out required fields
I have a problem that I don't know how to resolve: We have a SharePoint list and we use the list to store our reports. We complete about ten reports per month and the columns list things like start date, end date, status, result of report, summary, rating etc. Some of these fields are required to be filled out and some are not. The issue though is that at the beginning of the month, we add all of the new upcoming reports to the list and leave the status as In Progress. We do this so that we can generate an ID number from SharePoint (that number is then written on our report). Once the report is complete a couple weeks later, the team lead goes back into the SharePoint list, fills out the the remaining columns with their results and flips the status to complete. If I put restrictions on each column, like making certain fields required, it will prevent us from being able to generate an ID# because when we create the ID # at the beginning of the process, we would have to fill out the required fields which we can't do until it is complete. How can move forward with this?4KViews0likes5CommentsImporting multiple Excel files into Sharepoint that are each being updated daily (same headers)
Hello everyone, Help, please. I would like to import multiple Excel files into a Sharepoint list. The Excel files all have the same headings, although they will have different information in each column. There are 15 files representing 15 different areas of the company. Each file will have the company area in column A e.g. Company Area 1 (first file), Company Area 2 (second file) etc. The files will be updated on a daily basis so the import must recognise this and place new records in new lines in Sharepoint i.e. not overwrite the record beneath. Is this possible? Many thanks, Pillsbury33.Solved2.1KViews0likes1CommentList View >5000
Hi all. I'm working with SharePoint with a list of greater than 5000 items and growing by the day. I'm in Classic View and I've created a view specifically for current 6 months but I'm unable to view my items. The columns to be used as filters are: 1. 6_Month_Start (Indexed) 2. 6_Month_End (Indexed) 3. Department (Indexed) The rules for the view are: 6_Month_Start is less than or equal to [Today] AND 6_Month_End is greater than or equal to [Today] AND Department is equal to GA So, the question / issue is this. Everything is indexed and the return of items should only be 279. Why am I receiving that my list view surpasses the threshold? Side note: only Department of GA has more than 5000 entries in total but it shouldn't affect the view, right?1.2KViews0likes3Comments