Microsoft SharePoint

37K

Solutions

19K

Contributors

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Share tech news, updates, or what's on your mind.

Sign up to Post

I am using the following calculated field formula which works well.

=IF(F01="YES",1,0)+IF(F02="YES",1,0)+IF(F03="YES",1,0)+IF(F05="YES",1,0)+IF(F06="YES",1,0)+IF(F07="YES",1,0)+IF(F08="YES",1,0)+IF(F09="YES",1,0)+IF(F10="YES",1,0)+IF(F11a="YES",1,0)+IF(F12="Yes",1,0)+IF(F13="Yes",1,0)+IF(F14="YES",1,0)+IF(F15="YES",1,0)+IF(F16="YES",1,0)+IF(F17="No",1,0)+IF(F18="No",1,0)+IF(F20="No",1,0)+IF(F21="Yes",1,0)+IF(F22="YES",1,0)

What I need to ad is in some cases the question needs to meet two criteria...

Example

Right now if F01=Yes then I tally but I need to now tally only if FO1=Yes and TCV is > 25000000
0
Cloud Class® Course: CompTIA Cloud+
LVL 12
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

I'm looking at all the sites that have been created on the Site Management page (office 365/SharePoint).

I've noticed that sites that have been created by someone other than the company administrator (me) i don't have admin rights to it.  Shouldn't the company admin have global admin rights? If the group owner should leave the company i should be able to delete the site.
0
Dear Experts

We have marketing, sales, customer care, projects, legal, finance , accounts , admin, HR and many stake holders for each department and also management team who would like to know the daily/real time, fortnightly reports from every departments and from every branch office like region wise and all put together i,e  consolidated report and finally COO/CEO/CFO and MD get the numbers report,  though we have multiple systems like for sales and marketing SFDC and for some entry level ERP and few departments are operating with spreadsheets, we are looking for the solution where reports and associated data mainly reports from many systems like SFDC, ERP and spreadsheet all the reports of these are hosted in some location and by using some solution and create the reports and accessible to the stakeholders, please let me know for this process automation what solution would be a best while I understand we have to integrate applications/integrate with BI tool but this would take much longer time we are looking for some interim solution, at present we are using nextcloud for file share and sync can we ask users to palce their final versions of data in the folders and then use a solution like share point /ms access/Microsoft SQL server to achieve this process automation and reports for all the stake holders , not sure if sharepoint would be the solution, can you please suggest software solution for this so that we can go for that and search for software person skilled on …
0
I keep getting an error on the following, where am I going wrong?

=IF(AND([status_pr]=”approved”,[status_sr]=”approved”,[status_dr]=”approved”),“Submission Approved”,IF(AND([status_pr]=”approved”,[status_sr]=”approved”,[status_dr]=”pending”), “Solution/Delivery Approved”,IF(AND([status_pr]=”approved”,[status_sr]=”pending”,[status_dr]=”pending”),“Pursuit Approved”,”Pending”)))
0
We have an app in Access 2013 that has links to SharePoint lists.  Every time we open the app it takes about 2-3 minutes to refresh all the links.  There are 27 links
I was wondering if there is a way to modify the refresh to check the tables last modified date and if it's older than one week (7 days) then refresh that link.

This is what we are using to refresh the links:
CurrentDb.TableDefs("tbl_Name").RefreshLink

Thanks
John
0
Is there a way to set permissions for my organization to restrict creation of additional sharepoint sites, Teams, and Groups, but allow all other default permissions?

I just dont want people in my organization to create sharepoint sites (and esp. MS Teams) and go out of control with all that.
0
I have a user that wishes to have their document library show everything in alphabetical order, regardless of whether it is a file or a folder.

Currently, if they display in alphabetical order, it will display all folders in order, then all files in order.

How do I change it, so they see all items in alphabetical order, regardless of what it is?
0
HI,

We have a Xerox scanner/printer which, despite spending two hours on the phone with support, we just couldn't get it to upload scans directly to SharePoint document library.

We managed, in the end, to get it to scan to a shared folder on a local NAS drive.

We now want to move across the content of this shared folder to sharepoint on a scheduled basis.

Can an expert please advise on the writing of a batch file or the creation of a scheduled task which would facilitate the moving over of these files every fifteen minutes or so?

Thanks in advance.
0
We use Nas boxes for network drives and SharePoint 2010 for versioning.

I would like to migrate to SharePoint online and use Windows 2016 as a file server. Has anyone used W2016 as a file server and do you have any pro's and con's.

Many thanks

Mack
0
Hi All,

I am looking into a way of Migrating Sharepoint 2010 on-premise which resides on a Windows 2003 server to Sharepoint online

I did see the below article but is not compatible on Server 2003.

http://expert-advice.org/office365/sharepoint-2010-on-premises-to-sharepoint-online-office-365-migration

Is there an easy way to do this?

I did see this software SysTools SharePoint Organiser, but would prefer a cheaper way of doing it if possible.

Thanks in advance, and any further information you need let me know
0
Cloud Class® Course: Python 3 Fundamentals
LVL 12
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Chrome Prompts for Credentials. we have ADFS SSO running in our environment. Previously it was working fine in IE/Chrome/Edge suddenly ten days before team noticed that the sites are asking for credentials. we fixed in Edge by adding the ADFS site to Intranet site in IE but issues with Chrome still persists.

when open sharepoint site, a dialog box comes saying ADFS site asking for Credentials.

on checking the sharepoint in chrome, we see the FedAuth cookie for the site is showing to Expire as the browsers session Ends, Not sure if this is the issue.

No recent patches done. Patching was done almost three weeks before.

Any suggestions are highly appreciated.
0
Is there a template for SharePoint which would help in building a webpart (form) which I can have users into answers to questions which each provide a score and in the end calculates an overall score from the user's entries? (each question would have a selection of answers which yield various +/- values. I am seeking to do something similar to the attached Excel docClient-CAB_Risk_Info_Matrix-EE.xlsm
0
Contractor came in and set up a Production SP site.  A duplicate site was set up for staging.  They have 2 different pool#s.  
If a .wsp file is created does it automatically update both sites?    
There are several sites on the farm.  If it does affect both sites then why doesn't it affect the other sites on the same farm.

There's 1 server 1 farm.

JS
0
Hi,

We are trying to move to SharePoint online. We have an access database which has a backend database and front end link. I copied all the files from the file server to the Sharepoint document library and connected it as a network drive to my PC. The front end is giving an error saying "Runtime Error 3043. Your network access was interrupted. To continue close the database and then open it again."

I tried to link the database as external data source but it gives an error saying cannot link to an internet-based source. Can someone advice how can we fix it?

Regards,

Ajoy
0
My company uses SharePoint O365 hosted at Azure and we have several document libraries, mostly all with MS Office documents in them on one of the SharePoint sites.

We want for these to open on the user's desktops using the native applications.  The users desktops are Windows 7, but going to Windows 10 in the near future.  All desktops have Office 2013, and we'll probably go to Office 2016 when we move to Windows 10.  So, we have desktops with Windows 7 & Office 2013 and Windows 10 with Office 2016 coming.  We are also moving from IE 11 to Edge with this change.

We have configured the SharePoint libraries to specify for the office documents to be opened in the client applications (launched from their browser), however this does't seem to work properly for the few users we do have using FireFox or Chrome (both the latest).  It only works with IE 11 and Edge.  When a user has FireFox or Chrome SharePoint insists on opening the documents on-line an only displaying to the browser.

How can we fix this?
0
Outlook prompts for password when connecting SharePoint calendar.
When I originally created the SP calendar I was able to connect, no prompt, worked great.
I removed the SP calendar and tried to re-add to Outlook and was prompted after confirming I wanted to connect to Outlook.
0
I have a SharePoint 2010 Site that has multiple (Probably in the hundreds) of Document Libraries, each one with their own set of unique permissions.  One user needs read-only access to every single library.  I am sure this can be accomplished via PowerShell script, but I know very little about scripting, and can't seem to find anything that will help me.  
So basically, I have a website https://sp.website.com/sites/specific_site/
in that site, I have tons of Document Libraries.  What I am trying to accomplish, is to give user "DOMAIN\first.last" "Read-Only" permissions to all of the document libraries, without having to go in each one and assign the permissions from there.  I don't want to remove or change any other permissions, I just want to add the specific user and give then "Read-Only" permissions. I know very little about scripting, so I kind of need this spelled out for me.

SP setup details:
*SP and SQL are on separate servers.
*SP Server OS: 2008 R2 datacenter
*SP 2010
*SQL server OS 2008 R2 datacenter
*SQL server 2008 ENT
0
Hi,

I have an SSRS report that contains images that are attached to a sharepoint list but when you export the SSRS report to PDF the pdf is 31mb (six photos).

I either need the photos optimised in sharepoint or optimised when the report is being produced so that the file size is much much smaller.

I have seen code options but not sure if code in the report, code in the sharepoint list or an event handler is the best.

I have also not deployed an event handler before.

But if you print to pdf from SSRS the file will be only a few bytes.

I cannot use the SSRS print option as I am using a product called SQL-RD to produce the dynamic reports and it calls the SSRS export function.

Regards

Barry
0
Hi

What is the best ASP.net control t use to build a list with multiple columns where you can edit values
in the list?

Thanks
0
Upgrade your Question Security!
LVL 12
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

i am unable to access one sharepoint site called it -expenses on office 365 portal-this is repeat problem

while i can access other sites

do i need to check on premise AD that i am member of that particular group.

we sync users through AAD sync and have ADFS server, anything to check ?
0
We have SharePoint running on our in-house server "SERVER1". We use SharePoint Designer to program SharePoint.
Somehow we messed up the file "EditForm3.aspx" when working on SharePoint Designer and need to restore it from a backup. Unfortunately we have no idea about the physical location of this file except that we know the following URL. So the question becomes how can we located this file physically from the following URL?

http://server1:8086/Lists/Turnkey Status Tracker1/EditForm3.aspx

Thanks
Jack

PS - The server is Windows Server 2008. It does not have Index Service running so we can't simply search for the file on the server.
0
Sharepoint online group selection (when sharing something) shows 2 options for a group name, one of which is proper, the second which resolves to "c:0-.f|rolemanager|{GUID}" when selected.

This occurs with only one user, when I search for a group name, I only see a single (correct) option.

What causes this? and what can be done to correct it for this user?

Christopher.
0
I am having an issue where the front-end servers are not displaying the SharePoint Sites. Currently only one of the Application server is working for SharePoint access. We will call this server APSE1
 
We have an alternate access mapping set up for the URL https://sharepoint.domain.com which points directly to APSE1. If I change the DNS record to point to either APSE2, FEDC1, or FEDC2, I get no response back from a web browser. Shouldn’t the Front-End servers each be able to provide access to SharePoint?
 
 
APSE1 – Application and Search Server 1
APSE2 – Application and Search Server 2
FEDC1 – Front-End and Distributed Cache 1
FEDC2 – Front-End and Distributed Cache 2
 
 
I was having some issues with the Reverse Proxy but I think that’s due to the front-end server/servers not working correctly.
0
I’m new to SharePoint and 365 and I always come across topics and subject matters about SharePoint list and how it relates to Powerapps.
Can an Expert explain how this can be build because I’m curious how powerapps relate to it?
0
I have an access database and have an front end from using Excel, I want to share the excel sheet with multiple people, they use to pull data from the Access database, can I connect to the database if I save it on OneDrive or save it to SharePoint ?

Thanks
0

Microsoft SharePoint

37K

Solutions

19K

Contributors

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.