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: Ruby Fundamentals
LVL 12
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

I have a Date Time Field in SharePoint 2013, and I am using it in a calculated field as below:
example data:  6/4/2018 8:31 AM

Below Calculated field:
=HOUR([Date Closed])-7

Problem: This returns only numeric hour based on 24 hour clock.  

For example when I use formula: TEXT(HOUR([Date Closed])-7,"hh:mm" ) ,  The result is (20-7) and results are 13 hours, which would be incorrect based on 12 hr. clock.

I would like to subtract actual time of (8:31AM-7AM)  with result in format hh:mm    -   1:30

Can anyone please assist with how to get result of  this in hh:mm based on 12 hour clock.

thanks,
0
Heads-up: Though its little tricky to explain my scenario i will still try my best to explain as clearly as possible.

I have 4 RadGrids(with Column Picker for each RadGrid) on same page & switching between Radgrids doesnt load the current RadGrid name when looking in view source. Though the Data is loaded for different RadGrids.
Issue is with Column Picker.

Requirement: On Change of a RadComboBox List value a different RadGrid has to loaded. Each RadGrid has a COlumn Picker too.
Column Picker -> (list of columns in RadGrid is bided on serverside to a RadListBox and shown in a RadWindow invoked using Javascript )

Basically i have 4 RadGrids(RadGrid1 through RadGrid4) each of which has CommandIteamTemplate -> & asp:LinkButton OnClientClick opens a RadWindow with list of RadGRid Columns whose Display value is True.
Also these 4 RadGrids are 4 seperate user controls with their own unique Javascript methods and Radwindows.

But When ever i chaneg my RAdCombobox value though a different RadGrid is loaded ... Column Picker still shows from the previous RadGrid. At this moment when i look at the view source it still shows previous RadGrid name with java script methods from the same previous RadGrid.

Example: On my Main Page,
Step 1: on page load, RadGrid1 from first user control is loaded with Column picker1 - which was loaded using Javascript1.
sample code in CommandTemplateItem.. <asp:LinkButton ID="lbtnCP" runat="server" …
0
Need to override lock file in sharepoint 2013. Users will open a file and then lock their system which locks the open file and need the ability to override the lock file?
0
cannont publish from sharepoint using INFOPATH 2013 on windows 10.
could publish from sharepoing using infopath 2013 on windows 7.

"infopath cannot save the following form: "*********"  network problems are preventing this file from being saved.
InfoPath cannot save teh following form:  "******" This document library was either renamed or deleted, or network proglems are preventing the file from being saved.

what are the easiest, most low cost solutions to this?
0
I had this question after viewing SharePoint 2010 Calculated Column Calculate Business Hours Between 2 Date/Times.


Can you provide a detailed explanation of your parameters for the numeric values that you are providing.
My business day is from 7am - 8pm :  total 13 hour day.
0
Hi,

Is there one example in SharePoint list that one date change would trigger one defined alert automatically? For instance, I put deadline column to beJuly18, and after two days, alert message would be automatically sent out.
0
2 questions:

1.  When using Sharepoint online, if i go into Admin centers and then Sharepoint there is a list of sites, I assume they are default sites. I assume those are for the whole company? If i create a new site I assume by default is is private and only i can see and access it unless i share it out or give someone else permissions correct?

2. is it possible to do the following create in a site
- 1 site that contains multiple folders
- each folder is assigned to a different administrator outside of the default administrator
- the 2ndary administrator is allowed to assign permissions to files within that folder to users
- each folder and files in there will have it's own permissions and enforced by azure AD
0
Looking for help with a javasript to help control fields on a sharepoint custom list form...

Variables are:

F01-a
F01-b
F01-c
F01-d

All questions are drop downs with initial allowable selections of Yes, No or N/A

if F01-a is No then F01-b , F01-c & F01-d either don’t show or are forced to N/A only
if question F01-b is No then F01-c & F01-d don’t show or are forced to N/A only
if question F01-c is No then F01-d don’t show or is forced to N/A only


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html dir="ltr" xmlns="http://www.w3.org/1999/xhtml">

<head><meta name="ProgId" content="SharePoint.WebPartPage.Document" /><meta http-equiv="Content-Language" content="en-us" /><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>
	Untitled 1
</title>
<!--mstheme--><link id="onetidThemeCSS" rel="stylesheet" type="text/css" href="../../_themes/Breeze2/Bree1011-65001.css" /><meta name="Microsoft Theme" content="Breeze2 1011, default" />

<style type="text/css">
.style14 {
	text-align: center;
	font-size: 11px;
	border: 1px solid #808080;
	background-color: #F3F3F3;
	font-family: Arial, Helvetica, sans-serif;
}
.style14a {
	text-align: center;
	font-size: 11px;
	border: 1px solid #808080;
	background-color: #A8C0DB;
	font-family: Arial, Helvetica, sans-serif;
}
.style15 {
	font-family: Arial, Helvetica, sans-serif;
	font-size: 12px;
	background-color: #FFFFFF;
}
.style16 {
	

Open in new window

0
Trying to troubleshoot Problems with SharePoint environment. Server: Windows 2012R2 Standard. SharePoint 2010 server version 14.0.7015.1000. We might have more than one issue here haven't narrowed down.

We have a user complaining that their Version history on Excel Does not display history or version on desktop apps example: Excel. (See Attached). When viewing on the SharePoint web portal we can see the modified and revision history.

We started looking into the logs and found countless numbers of Event ID 10016 errors:
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
{8BC3F05E-D86B-11D0-A075-00C04FB68820}
 and APPID
{8BC3F05E-D86B-11D0-A075-00C04FB68820}
 to the user **domain\username** SID (S-1-5-21-3100772813-4073630589-3070870144-1537) from address LocalHost (Using LRPC) running in the application container Unavailable SID (Unavailable). This security permission can be modified using the Component Services administrative tool.
File_History_All_Blank.JPG
Developer-tab-version-history-excel.JPG
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.

Hello,

I want to send remainder mail to the employee who apply for the leave only when his joining report is pending.
Having two list Leave request and other is for Joining report list.

1. Leave Request List:


2. Joining Report List:

Send remainder mail after 3 day of Reporting Duty only if he/she not fill his joining report.

Please give some solutions.
0
I am attempting to create a Powerapp from existing Sharepoint list. I am stuck on trying to get a drop-down list working with a column that has choices setup on the sharepoint list. Any tips? Datasource is fine, i can choose the correct columns but error is not very helpful
0
need connect different database as such Mysql and Oracle to the sharepoint by web service
but the issue is oracle cannot connect
i need online help
0
I want to be able to stop my o365 users from accessing one drive, SharePoint and teams from their home pcs and mobiles.

Conditional access and in tune seems to be the way to go. For mobiles it looks straight forward that the user must enroll their device. But what about laptops and pcs.

I want my company laptops (which are not all joined to the same AD domain) to be able to access where ever they go but I do not want these sane users installing on their home machines.

What should I do and please I can google : ) this question is specifically around pc access, thanks
0
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
The company I work for recently began deploying Office 2016 upgrades to end users previously using Office 2010. We've found that the accidental use of working with files directly from online SharePoint/OneDrive repository opposed to working from local files (which automatically upload to OneDrive) causes various issues with file upload conflicts, slowness working in files, etc.

Microsoft support provided a solution with a combination of a couple registry key creations/edits and Office settings to basically remove/hide OneDrive for Business and SharePoint from the File>Open and File>Save menus in Office 2016 suite applications for Windows 10, they unfortunately could not provide any solutions for Windows 7 and stated that this was not possible. Has anyone else ran in to this challenge that can give their insight and/or workaround?
0
We are using Sharepoint with OneDrive. We need to make it so that only the files we are using sync to our computers and then synced to back to Sharepoint and removed when we are done with it. Right now, everything in OneDrive cloud storage keeps trying to sync and it is filling up our local hard drives. Is OneDrive the correct tool, or is there a better way to accomplish this?  

When I install OneDrive I see the option to select which folders will sync, but cannot get down to the file level. Also, there are no options to have documents removed from local drive once we I am done working on them.
0
A consultant created our sharepoint site using livetiles. (Site creation was done, then they sent me out for back end sharepoint training.)
While I was getting training, I asked the instructor about livetiles, and his statement was that, based off of what he could see, anything we were using livetiles to accomplish, could be done natively in sharepoint online.

I mentioned this, and now have been tasked with creating the site without using livetiles, but maintaining the same look.
I don't know how livetiles is changing the top navigation bar, as shown in the image.
Navigation bar with Livetiles
When I create a new page, the navigation bar looks normal, like this:
without-livetiles.JPG
How do I mimic the livetiles look using native Sharepoint online?

Bartender_1
0
ImageHello Experts,

I have an Article Content Type that I'd like to display all of the Articles, on separate pages based on a Choice Field Item.  Any help on how I can achieve this is very much appreciative.
Using SharePoint 2013 On-Prem.  I don't need help on creating the content type, only on how to get them to display on their own pages that are page-able.  To also include the Title, an image, and part of the Body.
 
0
Cloud Class® Course: Microsoft Windows 7 Basic
LVL 12
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

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
Looking for some assistance with a sharepoint calculated field formula...

Four Fields
f01-a
f01-b
f01-c
f01-d

If f01-a=Yes & f02-b=Yes & f01-c=No
If f01-a=Yes & f02-b=Yes & f01-c=Yes & f01-d=No

in both cases field should be set to Yes if neither combination is true then field is No
0
SharePoint 2016 - Customize "Web Pages/Sites"?

My company started using SharePoint 2016. We (my team) were given a "Team Site/Portal" with pretty much full control.
I want to customize the look and feel and build it out.

Question is, what are the "boundaries/limitations" of what I can customize/ cannot customize? As in, can I create an
html page in an external text editor and upload it, etc. (as I'd do with a website/domain), or am I limited to having to edit
and make changes (as is) with what's there in the built-in edit controls?

Basically, just trying to get an idea of what I'd be able to do - supported web languages i.e. HTML5, Javascript, CSS, C#, etc.
and what kind of editors I could use i.e. VS Code, Sublime, or SharePoint "built-in" only?

Thank you!
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
I have the code below that I dug up here is the setup and what I am trying to accomplish

Q1A field- _x0046_47 Q1B field- _x0046_46 Q1C field- _x0046_45 Q1D field- _x0046_44

If Q1A = No then Q1B,Q1C & Q1D = N/A
If Q1B = No then Q1C & Q1D = N/A
If it gets to this point Q1C & Q1D should show Yes, No or N/A

$().ready(function () {
function getCascadingByDropdown(CascadingListTitle, LookupFieldName, DropdownValue, IsMock) {
    var dfd = $.Deferred();
    //Set IsMock as False in real ENV
    if (!IsMock) {
    } else {
        var values = [];

        values = ["Yes", "No", "N/A"];

        if (DropdownValue === "Yes") {
            values = ["Yes", "No", "N/A"];
        } else if (DropdownValue === "No") {
            values = ["N/A"];
        } else if (DropdownValue === "N/A") {
            values = ["N/A"];                
        }

        dfd.resolve({ 'values': values });
    }

    return dfd;
};
function FillInCascadingQ1B() {
    var Q1a = $("select[title='_x0046_47']").val();
    getCascadingByDropdown("Q1b", "Q1a", Q1a, true).done(function (data) {
        $("select[title='Q1b']").empty();
        for (var i = 0; i < data.values.length; i++) {
            $("select[title='Q1b']").get(0).options.add(new Option(data.values[i], data.values[i]));
        }
    });
};
function FillInCascadingQ1C() {
    var Q1b = $("select[title='_x0046_46']").val();
    getCascadingByDropdown("Q1c", "Q1b", Gate, true).done(function (data) {
        

Open in new window

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

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.