Community

1

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

0

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