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-

 

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