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!
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...
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...
Okay, so I got it to work in Excel and am hoping someone 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...
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...
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 >...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.