Cross Sheet Input Numbers

I need to imput numbers from a different sheet using

=Count for each line. If someone has a better structure idea this could be put into that would be appreciated. The issue I having to report numbers per month on the smartsheet using only cross sheet referencing.

What i have come up with so far is =Countif({C Type}, "300", {Operational Date}, "Mar 24")

The issue i have is to change that Mar 24 for each month for the numbers to be inputted. For now all numbers have been calculated manually and put in there

Find more posts tagged with

Accepted answers

All comments

Genevieve P.

Hi @Archie123456

What I've seen other members do with a sheet like this is to have a Top Row locked with the value to search for. Then you can simply reference the cell in the top instead of typing in something in quotes. That way you can drag-fill the formula left and right and it will change based on what value is in that top cell.

For example:

=COUNTIFS({C Type}, "300", {Operational Date}, [Mar-24]$1)

That $1 means it locks the reference to the FIRST row of the column [Mar-24]. Does that make sense?

Cheers,

Genevieve

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.