Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

Column IF formulas only nest seven deep.

  Asked By: Jedidiah Mayo         Date: Jul 10, 2005      Category: Sharepoint      Views: 303
 

That's not going be any help when I try to group my documents by month.

They're creating list items with a "Date" field and there's so many of
them, they want them grouped by month.

No sweat, I thought, I'd just calcualte a column from the date field
using Month([Date]) which returns an integer. So I'd like to convert
the integer to a meaningful string like "August."

So try to If(Month([Date])=1,"January",If(Month([Date])=2,"February
and so on and you'll get barfed on at 8, i.e. August.

Which would work fine if we were getting done on time i.e. June.

So who's got the great trick to group these items by month?

Do I have to get the creator to enter the month on the item itself?

Tagged:              

 

1 Answer Found

 
Answer #1       Answered By: Rigoberto Beard          Answered On: Jul 10, 2005       

I suggest you try using the TEXT function to extract the month  name from
the date  (rather than using the MONTH function).

For instance, =TEXT(Date,"mmmm") will give the month as a word.

 
Didn't find what you were looking for? Find more on Column IF formulas only nest seven deep. Or get search suggestion and latest updates.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].