Formula Copy/Paste Issue

I have the below formula to extra a Quarter based on my column "Expected Close Date". The fiscal year begins 10/1. When I copy the formula to other rows it displays the same number (i.e. January showing as Q4 when formula is pasted when it should be Q2.

=IF(MONTH([Expected Close Date]@row) >= 10, "1", IF(MONTH([Expected Close Date]@row) <= 9, "4", IF(MONTH([Expected Close Date]@row) <= 6, "3", IF(MONTH([Expected Close Date]@row) <= 3, "2"))))

Find more posts tagged with

Formulas

Accepted answers

Colleen Patterson

@Joe R, the way your formula reads is that if the close date is greater than 10, make the cell return 1, if it is less than 9, make it return 4. So in this case it would not show as anything other than those two options. I recommend changing to the following:

=IF(MONTH([Expected Close Date]@row) >= 10, "1", IF(MONTH([Expected Close Date]@row) <= 3, "2", IF(MONTH([Expected Close Date]@row) <= 6, "3", IF(MONTH([Expected Close Date]@row) <= 9, "4"))))

It needs to have a "this is not true so I need to keep going element in it.

All comments

Colleen Patterson

=IF(MONTH([Expected Close Date]@row) >= 10, "1", IF(MONTH([Expected Close Date]@row) <= 3, "2", IF(MONTH([Expected Close Date]@row) <= 6, "3", IF(MONTH([Expected Close Date]@row) <= 9, "4"))))

It needs to have a "this is not true so I need to keep going element in it.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.