I've been trying to find a solution to this but I'm coming up empty.  Long story short, we use a Smartsheet form through a web browser on a phone to collect information.  It's sort of an inventory process.  At the bottom of the form there is the option to submit files or photos in which we take


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