Best Of

Try something like this.

1️⃣ . Add an Autonumber column (if you don't have one already). I've named mine RowID.

2️⃣ . Add a column called Duplicate and make it a Flag type column.

3️⃣ . Add the below formula and make it a Column Formula.

=IF([Invoice Number]@row <> "", IF(RowID@row <> INDEX(COLLECT(RowID:RowID, [Invoice Number]:[Invoice Number], [Invoice Number]@row ), 1), 1, 0))

This formula will flag any duplicates after the first.

Did that work/help?

✅ Remember! Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏

You can look at the individual checkbox cell's history, but that doesn't really lend itself to scalability. Automations only record a DATE, which obviously won't work for your use case. The workaround I've used in the one case I had to record time is simliar to described here - it isn't pretty, but it works. I'd be delighted if anyone else can offer something that's a bit more elegant than this trashfire. 😀

1. The sheet on which this checkbox appears will need to have some kind of a unique identifier for each row. If you already have something you can use (like an order number or an employee ID or something that shouldn't be repeated on the sheet EVER), great. If not, add an Autonumber column.

2. Create a COPY ROW automation that is triggered when your box is checked. Copy that row to a new sheet whose entire purpose is to create this timestamp. On that NEW sheet, be certain a Created Date column exists. (If it already does on your main sheet, you'll need to test and possibly play with column names and/or types - you're trying to capture when the row is created on the NEW sheet and not the original sheet.)

3. On the NEW sheet, split the date and time of the Created column into separate cells with Text/Number type - use formulas like =LEFT(Created@row, FIND(" ",Created@row)-1) to accomplish this. Only column type Text/Number will retain the timestamp, so you're converting the data type by doing this split.

4. You'll then be able to look up that new "timestamp" cell using your unique identifier from #1 to pull the time over. You can use the TIME formula to do whatever calculations you need to.