Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. richardlpalmer

    Calculated Column Formula (Nesting Help)

    Running MOSS 2007 and have created a calculated column. I could use a hand coming up with a proper formula for it. There are 3 states the calculation needs to display (New, Refresh, <blank>). Here is what the formula needs to accomplish: IF ORD >= TODAY, "New" IF ORD < TODAY & NRD >= TODAY...
  2. richardlpalmer

    Comma Displayed in Calculate Result

    I have a caluclated column used to calculate a fiscal year. [tab]=IF(NextReleaseDate=DATE(2009,7,1),YEAR(NextReleaseDate),IF(MONTH(NextReleaseDate)<7,YEAR(NextReleaseDate),(YEAR(NextReleaseDate)+1))) It gives a correct year, but the displayed result is less than desireable due to the addition...
  3. richardlpalmer

    Excel Formula Translation

    Goal: I need help translating a formula that works in Excel into something I can use in a Calculated column in SharePoint. More specifically I need to understand what the pieces of the formula are doing so I can then get it to work in SharePoint. Scenario: I've been able to find much support...
  4. richardlpalmer

    Caluclating Dates From Text

    Goal: I would like a column to display a "Next" date by comparing text values in one column to "today". This is a rough mock-up of what I would like to end up with (ideally without the zeros for h/m/s but I'm not too picky at this point): Scenario: I have two columns. The first is a column...
  5. richardlpalmer

    Powerpoint/HTML

    I'm new to Sharepoint and have searched this forum for the answer but haven't found it. So here's my first noob post. What I'm trying to do is embed a powerpoint slide in a webpart, smack dab in the middle of a web part page. To give a comparison it would be like having an iFrame on a static...

Part and Inventory Search

Back
Top