Search results for query: *

I have done libraries from parent to sub and vice versa in 2010 and 2013 and SP Online. The problem is in SP online after I have inserted the webpart onto the page and try to Check in/Out, delete, etc. a file it gives me this error message: The server has encountered the following error(s)...

We currently have a Web application that exists on a physical server that utilizes an automated PHP function to create print folders on a file share. We are currently migrating the environment to the cloud, and have been told we will no longer have the functionality to provision file shares on...

I have a document library that has check out and versioning enabled. When you check out a file to upload a new version, it wipes the custom field info for the document....which is another issue I am running down. The MAJOR issue is after you re-enter the custom field information and go to...

We are in the process of migrating to SP 2013 and I have to create a document library with cascading drop downs. I have accomplished this in SP 2010 with lists, but I have only been able to locate snippets of ways to use third party implements to accomplish in a document library. I cannot use...

I have been reading all day the options and answers that are out there for limiting the TOC to sub-sites. I have tried the SOAP Data Source option and inserting the Data View in the page, this does nothing. I have tried creating a document library and adding this code to a text file, adding a...

I have the following list: File Name [tab][tab]Review 1 [tab] [tab]Review 2 [tab][tab][tab][tab]Review 3 [tab] # 001_SOC [tab]Jones/Working [tab] Nelson/Complete [tab] Haim [tab][tab][tab] 1 I need to count the number of Review columns that contain the word complete. I need to count the...

Thanks Skip!~ The workbook is created manually, so there is no external data populated in any of the tables. Worksheet Outline has all the columns we are tracking for a pursuit, then my idea is to have different tabs for Writing Assignments, Compliance, Production. This would give each person a...

This is actually a two fold question. 1) I need to bring from worksheet "Outline" only the rows that don't have multiple specific content like "Tech Section", "Tech Major Tab", "Tech Minor Tab" into worksheet "Writing Assignments". The criteria content is in one cell and starts at H11. 2) I...

So, when I start typing a choice in the drop down cell it does not show me possibilities? Can I do something where when I type "wes" it will automatically show me "western"? If do I have to scroll down each list to find it? I am probably not calling it what it is supposed too...? Thanks!~

Is there any way to setup conditional formatting across multiple cells without having to do each individual one? I have a budget spreadsheet like this: Role [tab] [tab][tab] [tab] Resource [tab] [tab][tab] [tab] [tab][tab] [tab] Aug 20 [tab] Aug 27 [tab] Sept 3...

I have a Column titled Scope that is fed from a named range on another sheet. I also have code that allows you to select multiple items from the list and they populate the cells putting each choice on a seperate line in the cell. When I select 2 or more from the list I get an error "The Value...

Right now I have data in 60 rows.

I would LOVE to normalize the data!~ My skills in Excel are keeping me from accomplishing that, looks like I need to learn how to make a database in Excel while I work on the Access Database.

Sorry, hard to turn off the jargon!~ :) OK, see if this is better. There may be 1 or 2 people working on each project (Bid Mgr and Bid Crd) The way the data sheet is setup it shows both people on one row to consolidate the notes and keep down multiple data entry. I need to split that out on...

Will do!~ I have a data sheet with the following information (there is other data, but shortned): Pursuit Name Pursuit ID Bid Mgr Bid Crd Date Assigned Pursuit One GFGDFGD43 Smith 1/1/2011 Pursuit Fly By LDSOEMG76 Doe Sparrow 3/4/2010...

Good Monday Morning!~ Getting an early start this morning!~ I have a Pivot Table that looks like this: Bid Manager Doe, John Pursuit One Pusuit Twelve Pursuit Gator Smith, Jane Pursuit Fly By Pursuit Forty-Three To the right of the Pivot Table I have: 2/6 2/13 2/20 2/27 3/5 3/12...

N1GHTEYES It worked...followed the same direction in the original file and it worked!~ Thanks so much, it was my first time to use an array formula!~ :)

xlbo - No error cells in the range. N1GHTEYES - I do have the range named Bid_MGR, did the CTRL - Shift - Enter at the same time...though not sure how well I am hitting them at the same time. Still getting the Value error....

Thanks everyone for all the help!~ I have tried both xlbo =SUM(IF(FREQUENCY(MATCH(IF(LEN(Bid_Mgr)=0," ",Bid_Mgr),IF(LEN(Bid_Mgr)=0," ",Bid_Mgr),0),MATCH(IF(LEN(Bid_Mgr)=0," ",Bid_Mgr),IF(LEN(Bid_Mgr)=0," ",Bid_Mgr),0))>0,1))-1 N1GHTEYES SUM(IF(FREQUENCY(MATCH(IF(LEN(Bid_Mgr)=0,"...

Skip I created the Named Range Bid_MGR, but I cannot add a space to the blanks, as another formula then sees that that cell is no longer blank and counts it for another cell. Plus, I am not the daily user of the spread sheet, asking someone to add a space to every cell would not work.