Check box - how to auto record user details once selected

Brett Hill

Hi Guys,

 

I am using a checkbox to indicate when a particular task has been completed, but i need it to automatically record the user who changed it and when this occured. Can anyone help me with this, or suggest another way to make this work.

 

Thanks in advance,

 

Brett

Tony Davidson - SmartSheet Certified User 2016

If they are a shared user this would be recorded in the sheet automatically with the system fields as "modified by" and "modified date".  If these are not columns in your sheet you will need to add them.  I hope that helps!

Kennedy Stomps

Hi Brett-- Tony is correct in that you can collect data in a Modified By or Modified Date column, but keep in mind that this will update when *any* changes are made to a row, not just changes to specific columns. Let me know if this won't work for you and we might be able to brainstorm some other solutions. 

Brett Hill

thanks Guys, i have used the right click option on the individual cell and View history to get the desired result. I dont need to display this on the sheet, but it will allow me to see who changed a particular cell.

Galen Dalrymple

Brett: you can still use the Modified By and Modifed Date and make them hidden columns.  That way when you want to see who modified it and when in detail, simply unhide all columns and then hide them again when you're done.