Search results for query: *

Is there a way to create a data view to only show projects assigned to the user? Thanks, Kevin

Thanks Carl. Both formulas ended up working in SharePoint. I did later realize that the dates in the list spanned more than two fiscal years so I expanded the formula to fit any date range. =IF(MONTH([start date])>=7,CONCATENATE("FY",(YEAR([start date])+1)),CONCATENATE("FY",YEAR([start date])))

nevermind. I answered my own question. IF(([start date] > "6/30/2010"+0), "FY11", "FY10")

Hello All, I am trying to create a calculated column using an existing column that contains dates. The statement is as follows : IF([start date] > 6/30/2010, "FY11", "FY10") However, sharepoint does not seem to be reading 6/30/2010 as a date and keeps giving me FY11 as the return value even...

Thanks guys

Hello, I am using a combo box to lookup records in a form based on Vendor ID. If the user enters a vendor ID that is not in the table the form defaults to the first record in the table. How can I have the form display a pop-up notifying the user that the Vendor ID is not in the system and...

Yes Thanks.

Hello All, I am running Office 2007 and can use SUMIFS to sum all IF statements. However, my collegues are running on 2003 - How do I create a similar statement in excel. I have tried using nested IF's but it did not work. My SUMIFS statement is here: (SUMIFS('Sheet 1'!A:A,'Sheet 1'!X:X,"5...

Is it possible to inform all members of a document library when a document is posted? Thanks

I do not see the incoming email option in the settings for task lists. Is it possible for users to send documents via email to a project task list in MOSS 2007?

Hello All, I am trying to move multiple folders that exist in a document library (MOSS 2007) into a new folder created within that same document library. How can I do this? Thanks.

I have an excel document containing merged cells. However, when text entered into a merged cell overflows into a larger space than the merged area the cell does not expand. All merged cells are wrapped. Is there a way to have the merged cells expand when needed? Thanks.

perfect! I did not know about the unlink function. Thank you.

Hello All, I have two sections in a five page word document. The footer of the document contains the page number. The first section has three pages and is numbered 1-3 of 3. The second section is numbered 1-2 of 2. Is there a way I can remove the page numbers from the footer of the second...

Hi, I have a very complex swim lane diagram in igrafx and re-creating the whole thing in Visio would be a complete waste of time. Is there a way I can convert the igrafx document to a Visio document? Sotware being used: iGrafx FlowCharter 2006, Visio Professional 2003 Thanks.

I wanted to add some more information There are five fields in the table [ItemNumber], [CreateDate], [PONumber], [OpenQty], [Supplier] In addition to finding the last purchase order created (Max[CreateDate]) for each item is it possible to only return the largest qty if there are more than two...

Hello, I am working with a purchase order table that has a field called [CreateDate]. Each [ItemNumber] might have multiple purchase orders with a different [CreateDate]. How can I run query to only show the records for the last created puchase order for each item? Thanks, cordeiro82

Thanks guys. I would like to piggyback this question with another one. Now that I have 6 slots for future orders my crosstab looks something like this Material | Today | 1 | 2 | 3 | 4 | >4 A B C When I try to link...

Hello All, I have a future orders table that contains a date field [datedue]. The table is refreshed everyday, and the dates begin with the day of the refresh onwards. I would like to create an additional field that is populated with the following text: "Today" for min[datedue] (which would...

Hello, I currently have a Query that calculates the number of days that an order is late using Now()-[tableX].[DateX] The problem with this is that the number returned is the count of calendar days and not business days. Is there a way to count only business days (Mon-Fri)? Thanks, Cordeiro82