Re-write a formula to make it Column Formula compatible

I have Concept phase projects that can result in multiple Phase 1 projects being generated from one Concept Review.

I want to calculate the time in the Concept Phase for the first project from that Concept (the Approved Gate 0 UID), but mark it N/A for any subsequent references to that UID.

I figured out the formula below which does what I want, but it anchors the COUNTIF in the first row ([Approved Gate 0 UID]$1), which precludes me from making it a Column Formula.

Is there another way to write make this work without cell or absolute references? I'm hitting a wall….

=IF(COUNTIF([Approved Gate 0 UID]$1:[Approved Gate 0 UID]@row , [Approved Gate 0 UID]@row ) = 1, [Gate 1 Approval Date]@row - [Gate 0 Approval Date]@row , "N/A")

Thanks in advance,
Mike

Find more posts tagged with

Formulas

Accepted answers

All comments

There are no accepted answers yet

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.