Recent content by richardlpalmer

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

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. :)

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?

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

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!

Thanks niceguy, but when I attempted this it made the outcome negative:

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

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

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

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

Any ideas at all?

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

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

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

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