How to capture the Name of the person who changes the column value?

SIS · 01/11/22

Hi all,

I'm trying to to capture the name of the person who does the final change in a material release in a process. Please see attached. The goal is to have the name of the person who clicks release (which is the final progress status).

Do I need a formula for this?

I used created by option in the sheet. Not sure if modified by will be an option as there will be multiple people changing the progress as it moves forward.

Thanks a lot =)

Column value capture.png

Andrée Starå · 01/11/22

Hi @SIS

I hope you're well and safe!

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 support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå · 01/11/22

Hi @SIS

I hope you're well and safe!

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 support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SIS · 01/11/22

Thanks So much Andrée

Andrée Starå · 01/11/22

@SIS

I'm always happy to help!

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

BlackForest · 06/12/24

Hi André,

I followed your approach but the workflow is changing the last modified by to a auto-generated value and I no longer see who modified the record last? Any suggestion?

cheehoe111222 · 08/08/24

https://community.smartsheet.com/discussion/comment/440421#Comment_440421

any updates on this? or we have to use data shuffle or data mesh?

How to capture the Name of the person who changes the column value?

Best Answer

Answers

Help Article Resources

Categories