Visible audit log instead of "view cell history" for numerous lines of data

hi @VictoriaL do you have datamesh? If so, you could make this work. You would need a unique id for the row (I’ll assume that’s the Row ID for now). I had ChatGPT write the rest of the instructions:

Certainly! Here's how you can achieve this using Smartsheet's DataMesh feature along with helper columns to record the user who checks a box:

Step-by-Step Instructions

1. Set Up Your Sheet

1. Open Your Smartsheet:
   • Navigate to the Smartsheet where you want to implement this automation.
2. Add Columns:
   • Add a checkbox column, e.g., "Task Complete."
   • Add a "Checked By" column (Text/Number type) where the name of the person who checked the box will be recorded.
   • Add a "Helper" column (Text/Number type) to assist with the automation logic.
   • Ensure you have the "Modified By" system column visible in your sheet.
   • Ensure you have a Row ID system column

2. Create a Helper Column Formula

1. Enter the Formula:
   • =IF(AND([Task Complete]@row = true, ISBLANK([Checked By]@row)), [Row ID]@row, "")
   • This formula checks if the "Task Complete" checkbox is checked and the "Checked By" column is blank. If both conditions are true, it displays the Row ID; otherwise, it leaves the cell blank.

3. Set Up DataMesh

1. Create a DataMesh Configuration:
   • Open DataMesh and create a new configuration.
   • Source Sheet: Select the original sheet with your helper column and "Modified By" data.
   • Target Sheet: Select the same sheet to map the data back. (a datamesh configuration can work on a single sheet)
2. Configure Mapping:
   • Lookup Values: Choose the "Helper" column in the source and the Row ID in the target sheet
   • Data to Copy: Select the "Modified By" column data to be copied to the "Checked By" column.
   • Set up the DataMesh to run immediately.
3. Save and Run DataMesh:
   • Save the configuration and run it to ensure it works as expected.

What happened: someone checks the checkbox. The helper column sees the checkbox is checked but the Checked By column is blank, so it displays the RowID. The datamesh copies the name from the modified by column to the Checked By column. Now the Checked By column is not blank, so the helper column goes blank and the datamesh won’t run again, giving you the name of the person who checked the box at the time the box is checked.