Formula for Resource Type, Resource Name and Year

Hello - We have set up a sheet to pull from a Master document to include Resource Type, Resource Name and Year. The Year is from a Helper column. Can someone review the current formula we have to identify where we went wrong to no pull "zero" as the result vs the actual number.

Before adding in the Help Year and Reference, I was getting a result with the following formula: =COUNTIFS({07. Operations Project List Resource Type}, [Project Manager]$3, {07. Operations Project List Resource Name}, $[Resource Name]@row ).

Thank you for any guidance.

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Ok. So that formula outputs a text string. I am assuming that you are manually typing the number in the metrics sheet. Manually typing is a number. So even though they look the same, one is a number and the other is text, so there isn't really a match.

Try wrapping the whole MID formula in a VALUE function.

=VALUE(MID(………………..))

All comments

Paul Newcome

What exactly is the formula in the helper column you are referencing?

JNash

MID([Project ID]@row , FIND("-", [Project ID]@row , 1) + 1, 2)

Paul Newcome

Try wrapping the whole MID formula in a VALUE function.

=VALUE(MID(………………..))

JNash

Thank you - That worked!

Paul Newcome

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.