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!

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

Recent content by richardlpalmer

  1. richardlpalmer

    Calculated Column Formula (Nesting Help)

    Thank you for the help. Your idea was excellent. It didn't work that way but changing where the parenthesis were located did the trick. =IF([ORD]>=[TODAY],"New",(IF(AND([ORD]<[TODAY],[NRD]>=[TODAY]),"Refresh",""))) Oh, and in case anyone else is looking for information on this, here's a great...
  2. richardlpalmer

    Custom workflow that runs once a day?

    Darn, I can't find the workflow I've been tweaking for a current client -- handles this "counting" scenario. But I'll hit it after I've gotten some sleep and will see what I can pull up for you. :)
  3. richardlpalmer

    Custom workflow that runs once a day?

    You can do it a couple of ways. These assume you're using SharePoint Designer for your workflow, though. You can use the Pause Until Date or the Pause for Duration workflow actions. But are you trying to run the workflow on an entire list of items?
  4. 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...
  5. richardlpalmer

    Comma Displayed in Calculate Result

    Okay, I used a slightly different version of what you provided and it worked perfectly. =TEXT(IF(NextReleaseDate=DATE(2009,7,1),YEAR(NextReleaseDate),IF(MONTH(NextReleaseDate)<7,YEAR(NextReleaseDate),(YEAR(NextReleaseDate)+1))),"0") Thanks for the help!
  6. richardlpalmer

    Comma Displayed in Calculate Result

    Thanks niceguy, but when I attempted this it made the outcome negative:
  7. 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...
  8. richardlpalmer

    Excel Formula Translation

    Thanks. I originally started this quest in the SharePoint forum in Tek-Tips but received nothing in reply. I looked elsewhere (including the other forum you referenced) and the only area I could find help was in Excel, which helped me with the above formula. As MOSS is an Office product I...
  9. richardlpalmer

    Excel Formula Translation

    That does help. Thank you. I was hoping a SharePoint person would also see this thread as I know Excel and SP don't translate exactly but much of the functionality does/can. If you have any ideas on a good SP help source I'll be very receptive...
  10. richardlpalmer

    Excel Formula Translation

    I'm not sure how to answer that. Array formulas are an Excel thing, aren't they? I don't know how that translates to SharePoint...
  11. richardlpalmer

    Excel Formula Translation

    Any ideas at all?
  12. richardlpalmer

    Excel Formula Translation

    Looking at this from a database perspective (and Excel would work with this as well) you can have data in a couple of ways. 1 to many 1 to 1 I have a very large list that is "1 to 1". There isn't an option of converting it to a "1 to many". I have a form (InfoPath) where Users can select...
  13. richardlpalmer

    Excel Formula Translation

    Oh, sorry about the misunderstanding. I was originally trying to accomplish this in SharePoint but haven't been able to find support. So I duplicated the problem in Excel and was able to quickly find a solution (above). This was the experiment -- can it be accomplished in Excel? Now what I'm...
  14. richardlpalmer

    Excel Formula Translation

    Skip, the value of A2 is: 2009-03-27 00:00:00 2009-04-10 00:00:00 2009-04-29 00:00:00 2009-05-13 00:00:00 2009-05-27 00:00:00 It's all one text cell. I did this in Excel as an experiment - the data is in a text column within SharePoint. So there's no real option to "change the FORMATTING of...
  15. 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...
See more

Part and Inventory Search

Back
Top