UNPARSEABLE Error

Hi.

I am trying to pull from my contracts management sheet, the number of "Executed" contracts that have a "Y". For background info, the "Y" denotes the last and active executed contract in a series. I don't want it to count all multiple executed contracts/amendments just the most recent one.

=COUNTIFS({Sheet - Contract Management - Complete Lib Range 3}, "Executed", {Sheet - Contract Management - Complete Lib Range 4},"Y")

This is my formula and it worked perfectly ending at "Executed" until we made the "Y" Change and I had to update the formula. Now of course its not working.

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

I don't see anything wrong with the formula in your post that would be throwing that error.

Are you able to provide a screenshot of the formula actually in the sheet similar to the snippet below?

AliT

Thank you Paul. Right after I sent the question and went back to my formula it was working. Perhaps I just needed to save or refresh. Again, Thank you for the reply.

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.