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