Good morning! I'm trying to create a flag in my form receiver sheet to identify first entries vs. duplicates. This is to help me pull some metrics (counts) in other sheets. I have an equation that works row by row, but not in the very first row and also can't be converted to a column formula. What am I doing wrong? I'd like this check to run with every new form submission.
I didn't have a problem when I wasn't trying to separate first entry out from the duplicates 🤔
so I assume it has to do with limiting the count range?