Auto Fill "Completed By" Column based on Checkbox

Mike Hebert

Hi all,

Is it possible to have a column auto-fill in the name of the user who checks off a task as "done"? I know you can see it in the Activity Log, so I know Smartsheet is collecting this information, but I can't figure out how to get it into the sheet.

Chris Mondeau

Hi @Mike Hebert ,

One option that might work is using a combination of the 2 system generated columns; "Modified By" and "Modified" (these will show who last edited cell data, but not attachments or comments)

Then you can set up an automation to lock the row whenever a row changes where the "Complete" column is checked off, thus preventing any more edits to the row and modified by columns.

I'm sure others might have some suggestions as well, but maybe this is a start. Hope it helps!

Andrée Starå

Hi @Mike Hebert

To add to Chris's excellent advice/answer,

Please have a look at my post below with a method I developed.

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!