Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x

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

Hi,

I have a SharePoint 2013 list.
In it I have "1" column type Choice with values a1, a2, a3, b1, b2, b3, c1, c2, c3.
I would like to make calculated column "2" where, when I choose a1 or a2 or a3 the value is "a", if a choose b1or b2 od b3, the value is "b "and if I choose c1 or c2 or c3 the value is "c".
I tried with formula:
=IF(OR([1]="a1",[1]="a2",[1]="a3"),"a","b") , but it is functioning only for 2 values - combinations of "a" and "b", "a" and "c", or "b" and "c" , not for all of them.
Is there a way to do this?
Can you help me with the correct syntax?

Thanks in advance
0
Nothing ever in the clear!
LVL 1
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

I want to install a single sharepoint server (VM) on my network, for 20 users. I need to know the following;

1.How many cores are recommended?
2. How much RAM is recommended?
3. Other than 2012R2 server are there any other prerequisites that need to be purchased?
4. How is Shareppoint server pricing structured?
Any additional information will be welcomed as I am sure i am missing something
0
Hi Experts,

Please see attached. We have an SP site that links to a site that allows our HR dept to create a new user request. All users can access the site but no function buttons. We need to assign specific users to have access to the function buttons but don't know how. Browsed in IIS Right click the site (folder) add full access under under security, added the user as a contributor to the site. Not sure if this is share point or something different we need to do. We as administrators have access to the site with the functions buttons. As a baseline, we have one user that has access to the function buttons but cannot locate any folder or site or anything where we find his name to add an additional user. Any help would be appreciated.
SP-button1.JPG
SP-button2.JPG
0
Hi,

We are trying to create a folder structure in SharePoint by week number. For eaxample:

Week 1, Week 2, Week 3, etc.

The problem is that SharePoint lists the folders by the leading number. For example:

Week 1, Week 10, Week 11, etc.. (see attached)

We've created an ordered list folder option however that didn't work. Any suggestions are appreciated.

Thanks
0
I have a [Customer Code] list which lists every customer, their address and bank codes.
The list has grown beyond the 5000 (LTH) and users cannot now open it.

As it is not recommended to override he List Threshold Setting of 5000. How would the experts manage this list so that customer records can be quickly found/viewed/edited and new records can be added.
(I was thinking folders A-H, I-P, Q-Z although I prefer to avoid folders in SharePoint as it defeats the meta data capabilities).

At the moment it is just one link on the Quick Launch to the whole Customer Code page (in Data Sheet View).

Note: The whole list will still need to be exported to Excel occasionally, which as the Administrator I can still do (well, until the list reaches 20000!).

Thanks for your time
Neil
0
Hi

I created a content type in SharePoint online, and am now trying to delete that content type. I get the error that the content type I am trying to delete is still in use, and that I need to remove it from all lists or sites first.

So far I have tried:
  1. Deleting all documents that used this content type.
  1. Emptied the recycle bin after deleting the documents.
  1. Deleted the entire document library that used this content type.
  1. Downloaded SharePoint Online Client Browser from Github, but this doesn't show content type usage.
  1. Tried various powershell scripts, but the examples are not for SP online.
  1. Tried to use CSOM, but I cannot seem to find content type usage

Any ideas, code or scripts that can show content types usage for SPO would be much appreciated.
0
Hi,

Is it okay to install EX, SP and CRM on the same server or should I create separate VMs for each of them?
Can I integrate all these on a one domain?
Pros & Cons, Recommendations?

With kind regards,
0
Hi experts,

I am using SharePoint 3.0. I have a list that only I can access, but I would like to password protect it. Is there a way to do this?

Thanks.

Bert
0
Hello,
We have a 2003 Sharepoint server that we want to get rid of. How can we extract the actual files and put them in a file server? I was reading that they reside in a database but is there a way to extract the info?
Thank you in advance!
0
I need to automatically schedule a SharePoint workflow to repeat once every month.  Is there a third party scheduler I can purchase since SharePoint does not have a scheduler?
0
Independent Software Vendors: We Want Your Opinion
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

I manage a SharePoint 2010 Site Collection and have Full Control. I use SharePoint Designer to assist with many of my builds.

Recently, SharePoint Designer no longer works for me and gives the following error message:

"Microsoft SharePoint Designer cannot be used to edit web sites on servers different from Microsoft SharePoint Server 2013. To edit these sites, you need to use the same version of SharePoint Designer which matches the version of Microsoft SharePoint Server"

Again, the SharePoint Site Collection is 2010.
I get this error message when I try to use SharePoint Designer 2010 and I get the same error message when I attempt to use SharePoint Designer 2013.

Any insight or direction towards a fix or workaround would be greatly appreciated.

Thanks
0
Hi,

I have SharePoint 2013 on premise farm.  Internal users authenticate using AD accounts . it is possible to share sites with external users ( consultants) without creating them an AD accounts ??? if there is way to do this , thanks for sharing

Thanks in advance.

Best Regards,
0
I had this question after viewing Sharepoint 2013 - 500 INTERNAL SERVER ERROR.

I am getting the same error. I've verified SecurityTokenServiceApplicationPool is started and the user used is active.  Anything I can check? We are in a domain environment.
0
Hello?
Are SharePoint Foundation 2010 and 2013 free?
Could someone provide me with the doc or link to the best :) detailed step by step instructions how to install an configure them?
Thank you in advance,
Evgeniy
0
I have searched this all over and having an issue creating the solution. No solution addresses the issues below. Only shows how to create a custom content type.

Requirement:
1. Create a custom task list
2. Add custom fields
3. Carry ALL fields through the whole process. (ie. New Task, View Task, Edit Task) - All fields to show data
4. Selecting "View" task that has been assigned from email (Shows a form with ALL data from "New", not just a task with Start and Due dates with Approve / Reject) Don't want an additional link in the email that says "See Linked List Item".  I want the item data to show in the task.   This only makes sense.  Why would I want to select a separate list item to view the information I am trying to Approve / Reject?  If I'm going to Approve or Reject the Task, I want to see what I am Approving on the same form.
- I have created custom content type and it does create the Form in Edit and View that I need based on the Content Type, but no data follows it.  The Edit and View form sent to the email as a link sends them to a form with all the correct fields but no data.
0
Hi,

I have an interesting problem, we are working on sharepoint 2013 and sometimes, we have an unknown error with random PDF  or PPTX or whatever you want;

 dzd.JPGWhen we want to upload this kind of file, upload get stuck for 30mn and give us an unknown error.

  erg.JPG(translation: Sorry, for some reason this document couldn't upload. Try again later or contact your administrator. )

Btw our limitation is 2gb and the files that we upload : 3-8mb... Timeout in IIS is increased to 1200 (tried 120...)

I have no log... I'm a bit lost...
0
Hi,

I tried to embed a Power BI report using an iFrame in multiple way in Sharepoint 2013 onpremise. But still have the "loading data":



It's due to IE compatibility mode (need to be in IE11 or EDGE MODE)

I tried this : https://paultavares.wordpress.com/2015/01/20/how-to-render-a-sharepoint-page-in-ie-using-edge-mode-without-changing-the-master-page/ (not working or I miss something in his tuto)

and this: https://docs.microsoft.com/en-us/power-bi/report-server/quickstart-embed (not working)

And editing the masterpage: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\TEMPLATE\GLOBAL\default.master to add the meta tag : <meta http-equiv="X-UA-Compatible" content="IE=edge"/>.

Still the page is in IE10 mode when I check with F12:


Can you tell me where I should put the <meta http-equiv="X-UA-Compatible" content="IE=edge"/> or <meta http-equiv="X-UA-Compatible" content="IE=11"/> ?

here the aspx from my sharepoint page:
<%@ Register TagPrefix="WpNs0" Namespace="Microsoft.SharePoint.Portal.WebControls" Assembly="Microsoft.SharePoint.Portal, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"%>
<%@ Assembly Name="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"%> <%@ Page Language="C#" Inherits="Microsoft.SharePoint.WebPartPages.WikiEditPage" MasterPageFile="~masterurl/default.master"      MainContentID="PlaceHolderMain" 

Open in new window

0
I think there is no way via some type of code or setting that can be modified in SharePoint 2010 to limit sites so they open only in MSIE. Making it so that they do not open in Chrome and Firefox. But I just wanting a second opinion. So the question exactly is:

Is it possible to force MSIE to be used whenever a SharePoint 2010 site or page or other object is opened? This would have to be implemented via code or a setting in SharePoint.

Thanks
0
I'm on on premises SP 2013 but limited to SP 2010 workflows.
I have a long complicated workflow that I'm working on.  I need to backup it periodiocally so that I can restore it to its previous configuration if the workflow becomes corrupted (which it can during designer editing on rare occasion).
I can see the workflow detailed files under all files in the workflow library but can't download these directly from Designer.
You can't view this library as a normal library with views and it has special behind the scenes handling evidently even if you make that library visible to the browser.  
Since it's not a 2013 workflow, you can't save as a template.
Does anyone have the DETAILED steps for backing up the workflow files and then restoring them over top of a more recent change if needed.  I've attempted to download the contents of the workflow files themselves and then restore them but this doesn't work as SP keeps track of the the saved copy and the published copy separately.
I' ve read the blogs - please only answer if you have actually successfully and have restored a 2010 workflow back to a previous configuration.  
I've searched on the Internet blogs and here but can't quite get it to backup and restore properly on the same list.

EDIT:
If it matters - I don't care about preserving the state of previously running copies of the workflow.  It runs within a few minutes and finishes so there's no active workflows running under normal conditions.
0
Efficient way to get backups off site to Azure
LVL 1
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Dear EE experts,

We would like to ask on how to fix the sub-site in our SharePoint, we created a new sub-site and we add an embedded code (HTML script) into the main part of the site (center).
However, every time we access the site: http://our-server:2018/products/productSKU , it'll go or redirect to this site: http://our-server:2018/products/productSKU/_layouts/15/start.aspx#/ (please see the attached screenshot PRODUCTSKU_05.JPG), it will stop there and will not go to its normal look (please see the attached screenshot PRODUCTSKU_06.JPG). Then now, even we type it directly or check every link, which is correct, the screenshot from PRODUCTSKU_05.JPG appears.

We have no forgotten CSS &/or JS files, as it is located from jquery site. And we add some CSS manually...

I'm attaching the code here:
Yesterday, it was working smoothly, within sharepoint, but this morning, we have no idea what went wrong why it result differently.
<!doctype html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <title>Product SKU</title>
  <link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
  <link rel="stylesheet" href="/resources/demos/style.css">

	
  	<style>
	  .ui-state-active,
.ui-widget-content .ui-state-active,
.ui-widget-header .ui-state-active,
a.ui-button:active,
.ui-button:active,
.ui-button.ui-state-active:hover 
	{
		border: 0px solid #949292;
		background: 

Open in new window

0
Dear EE experts,

We would like to ask on how to remove the upper link in SharePoint 2013 (please see the attached screenshot).

Thank you and hope to hear soon...
ProductSKU_04.JPG
0
We recently took over a new client who was using an expensive 3rd party file sync for shared files and personal user files.  We want to migrate them to SharePoint / OneDrive (They already use O365 for Exchange/Office apps).   We would like to control access to SharePoint via Azure Conditional Access to grant access to only domain joined devices.  The on premises AD is domain1.local.  The Office 365 domain is domain2.com.   I do not care about having to manage 2 sets of user accounts and passwords.   Local AD is running on a Server 2012 R2 domain controller.

I configured Azure AD Connect on the local domain controller and synchronized with Azure.  I successfully joined a computer to the domain.  It then synced to Azure and is listed in devices as a Hybrid AD joined device.    However, when I try to access SharePoint online, I'm still getting denied access with the error that the device must be domain joined.  dsregcmd /status shows that the device is AzureADJoined.

Is it possible to have a hybrid domain with the local AD as domain1.local and domain2.com as the Azure domain?  We use sharepoint for a document library and have no issue requiring a separate sign in to access it either via a browser or the OneDrive for business app.  

If it is not possible to do this, what is the easiest way to change the local domain from domain1.local to domain2.com?  It would not be prohibitively awful to simply create a new local domain, but we'd like to avoid it if at all possible.
0
We're using SharePoint 2010 for our intranet site and I'd like to create a simple employee directory that would have their phone number and maybe email. We print up little cards with the employee extensions but it always seems right after we hand them out, we have staff changes. I looked online and it seems like all of them have a search functionality, which we don't need or want, I would just like a simple listing with name, phone number and email. Is there a simple way to do this?
0
We've created a SharePoint O365 site for document management for our enterprise.

We've got 2 specific document types with required metadata.  We've also created a library for one of these types to test from the type and removed the default type of document.  The goal is to restrict uploads to not let the environment become a mess like we've got with older solutions.

We really want to force entry of required metadata with uploads, which we understand isn't a native capability.  I'm sure others have had this need though so I'm hoping that someone can provided a technique for doing this.  I'm talking about end-user uploaded - we can provide all required attributes through a tool.

Would triggers of some sort be a mechanism to catch uploads and validate metadata?  Is there another technique?  Are there several?
0
Dear EE experts,

We would like to ask for tech support on how to edit css of SharePoint 2013 lists, we have several lists (custom list) and we would like to edit its CSS file.

So that we could insert the script that we would like to have...

Thank you and hope to hear soon...
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.