Identify cell instance count

Dave Schierman
edited 02/15/24 in Formulas and Functions

I’m looking for a way to identify a duplicate cell value in a row so I can mark it for removal to another sheet for archiving. Rows are entered via forms at the top of sheet that contain a “Product Name” and it’s status. I am referencing this from another sheet to find the current status of the product so I just need the latest entry for each product but would want to keep a few previous as well. Ideally, a formula that would denote 1st, 2nd, 3rd etc row instance.  Hopefully that makes sense.  Thanks

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!