How to view and use the Modified and Created fields in Smartsheet
Is there a way to capture the Modified By and Created fields in a sheet or report? I'd like to be able to create filters based on the current user in a sheet.
Multiple users giving input on one Sheet.
Concerns with data integrity and errors (overwrites, deletes, etc) from multiple users. Cannot lock at the Cell level so everyone can access/edit anything.
Create a filter to trigger when the current Assigned user name matches the Modified By user name (if the Modified By data can be captured when one is actively in the sheet). This information match would trigger a workflow to filter all rows except those that match the Assigned and Modified By columns.
Users modify only their rows of data and can add new rows for additional inputs with seeing any other users in the sheet (unless they deactivate the filter).
Any potential for this ?