Anyone know how to replicate this in an appsheet formula?
Text(COUNTIF($D$2:$D2,D2),“00#”)
It gives me the number of times DocID 3010 (or whatever DocID is returned from a set of criterion) is contained within or above this record’s row in my table. I’m trying to use this to create the true Key of doc ID 3010-001, then 3010-002, etc.
LinkedIn
Twitter
