Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Column IF formulas only nest seven deep.

  Asked By: Jedidiah    Date: Jul 10    Category: Sharepoint    Views: 1783

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?



1 Answer Found

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

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.