"Active Last Month" Calculation?

I have created a Calculation Sheet (feeding in to a Dashboard) with Columns including "Started Last Month?" and "Ended Last Month?". Row data therein is either "Yes", "No" (or "#INVALID DATA TYPE" - not worried about this at moment).

I then have a further column, "Active Last Month?", which I want to report "Yes", "No" (or "#INVALID DATA TYPE" - not worried about this at moment).

The latest (but simplest) equation to fail I have tried is:

=IF([Started Last Month?]@row)="Yes",OR(IF([Ended Last Month?]@row="Yes"),"Yes","No"))

Comes back as "#UNPARESABLE".

Can anyone give advice?!?

Many thanks

Find more posts tagged with

Accepted answers

Kelly P.

@Dan Edwards

It sounds like this is what you are looking for, but if not then please provide more detail.

=IF(OR([Started Last Month?]@row = "Yes", [Ended Last Month?]@row = "Yes"), "Yes", "No")

Hope this helps!

All comments

Kelly P.

@Dan Edwards

It sounds like this is what you are looking for, but if not then please provide more detail.

=IF(OR([Started Last Month?]@row = "Yes", [Ended Last Month?]@row = "Yes"), "Yes", "No")

Hope this helps!

Dan Edwards

@Kelly P.

That works perfectly - many thanks!

Had been struggling for ages...

Kind regards

Dan

Kelly P.

@Dan Edwards

Happy to help! 😊

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.