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

djpreece ✭✭
edited 12/09/19 in Formulas and Functions

Hi all

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


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!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!