Add one more condition to check project status

Hi @Paul Newcome I'm able to calculate projects falls under on time and delay for the month, I would like to check "project status" column and check for "completed",

=COUNTIFS({Month}, Label@row, {OTIF}, [Category 1]$4) im using this formula currently,

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

You would add another range/criteria set following the same syntax.

Joseph Aloysias - vSaaS Global

Thank you @Paul Newcome I got it.

Is there a way we can hide 'Zeros' in the dashboard? would like to show only values.

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.