Creating a formula that uses the output of a formula in another column

Becky Garrett

I have column that generates a True /False answer using the formula below:

=IF(ISBLANK([Published date]@row), "", (IF([Published date]@row <= [Date due]@row, "True", "False")))

I want to work out the percentage that are "True" in a separate column.

The formula I had created stopped working a while ago and shows as #INVALID OPERATION and I can't work out why:

=COUNTIF([Within Target?]:[Within Target?], "True") / COUNT([Within Target?]:[Within Target?])

(Column was set show as %)

Is anyone able to spot where I am going wrong?

Find more posts tagged with

Formulas

Accepted answers

All comments

Bassam Khalil

Hi @Becky Garrett

Hope you are fine, If your column [Within Target?] is checkbox type and if you traying to calculate the percentage of checked rows to the total rows please try the following formula:

=IFERROR(COUNTIFS([Within Target?]:[Within Target?], 1) / COUNTM([Date due]:[Date due]), "")

Becky Garrett

Hi,

The contents of the Within Target? column are generated by a formula and display as text - True, False.

The formula used is the one below:

=IF(ISBLANK([Published date]@row), "", (IF([Published date]@row <= [Date due]@row, "True", "False"))).

Using the above, altered as below, returns no results

=IFERROR(COUNTIFS([Within Target?]:[Within Target?], "True") / COUNTM([Date due]:[Date due]), "")

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.