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 derfloh 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)

    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

    ...come up with (but it doesn't work yet). I decided to just try the first part of the formula in SharePoint - you know, work it in pieces. =MIN(IF(MID([Dates],(ROW(INDIRECT("1:"&(LEN[Dates]+1)/20))-1)*20+1,19)+0>=[TODAY](),"true")) I know SharePoint wants certain things in brackets not...
  15. richardlpalmer

    Excel Formula Translation

    ...and is able to compare them as actual dates to today, giving me the next date after today. =MIN(IF(MID(A2,(ROW(INDIRECT("1:"&(LEN(A2)+1)/20))-1)*20+1,19)+0>=TODAY(),MID(A2,(ROW(INDIRECT("1:"&(LEN(A2)+1)/20))-1)*20+1,19)+0)) And while this formula works in Excel, I ultimately will need...
  16. richardlpalmer

    Caluclating Dates From Text

    ...here will be able to help translate this into something SharePoint might be happy with. :) =MIN(IF(MID(A2,(ROW(INDIRECT("1:"&(LEN(A2)+1)/20))-1)*20+1,19)+0>=TODAY(),MID(A2,(ROW(INDIRECT("1:"&(LEN(A2)+1)/20))-1)*20+1,19)+0)) This outputs the date in number format (and I've formatted the...
  17. richardlpalmer

    Show/Hide tables on a SharePoint page

    There are a couple things that come to mind. You can use Excel Services if the information is in that format (or can be managed in Excel). This can give a robust ability for Users -- they can use tabs of the workbook, do caluclations, etc. (whatever permissions you grant). You can also do what...
  18. richardlpalmer

    How do I create menus as a site-tab on the top navigation bar?

    I realize it's been a while since you posted this but let me see if I can help. The sample you showed has a collection of sub-sites in a heirarchy. If I understand your question correctly you're wanting all of the sub-sites to show on the horizontal navigation bar all the time. Site Settings >...
  19. richardlpalmer

    Caluclating Dates From Text

    Bump
  20. 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...

Part and Inventory Search

Back
Top