@column alternative / is there an @column function?

Hi everyone,

I've created a formula that I'd like to replicate over many columns. I know I can paste it and change the column number, but is there a way to instruct the formula use a numbered row (in this case, 20) and the current column? Something like @column

=COUNTIFS({April/May 2021 Boot Raw Data Range 1}, [Primary Column]@row, {April/May 2021 Boot Raw Data Range 2}, "Yes", {April/May 2021 Boot Raw Data Range 3}, =[Column3]20)

Thanks for your time,

Will

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

If you dragfill, the column in bold should automatically update.

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.