Flagging this Month or Last Month

Fboivin

I am trying to create a helper column to flag something as occuring "This Month" or "Last Month"

This is the formula I'm using.

=IF(Date@row = MONTH(TODAY()), "This Month", "Last Month")

It is saying #INVALID OPERATION. Not sure what I have wrong here.

Find more posts tagged with

Accepted answers

Carson Penticuff

=IF(MONTH(Date@row) = MONTH(TODAY()), "This Month", "Last Month")

You were on the right track.

Will the current and previous months be the only options? Will there be entries from prior to last month?

All comments

Carson Penticuff

=IF(MONTH(Date@row) = MONTH(TODAY()), "This Month", "Last Month")

You were on the right track.

Will the current and previous months be the only options? Will there be entries from prior to last month?

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.