Any way to use a cell value as a row number in another cells formula?

djpreece

Hi all

Anyway to get the row # from a cell value and use it in a formula?

Example

this works:

IF(COUNTIF([Assigned To]$974:[Assigned To]@row, [Assigned To]@row) > 1, "DUP”,1)

Now let's say Column1 row 23 contains the value 974

I would like to do this:

IF(COUNTIF([Assigned To][Column1]23:[Assigned To]@row, [Assigned To]@row) > 1, "DUP”,1)

Any ideas?

Thanks ahead of time!

-dp-

Find more posts tagged with

API and Developers

Formulas

Enhancement Request

Comments

Alejandra

Hi dp,

When creating a formula, you'll need to either select the range of cells or manually type the column name and row number —there currently isn't a way to use a cell value as a row reference.

If needed, more information on this can be found in our help article: https://help.smartsheet.com/articles/2476816-create-cell-column-reference-formula

Sign in to join the conversation!

Quick Links

Trending discussions

Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.
Join distinct collect with contains
Can someone help with this formula? Its not working as-is, but I also would like to use the "contains"/"has" for the leader column as I combined a bunch of contact columns. Here is my attempt to use has - Heres the references (other sheet) Month, all Leads, and R&B prog is the first one (project)