Capture name of last associate to edit / close out a line



I need to know who worked a specific line in Smartsheet. I currently am using the "modify by" column type and a drop down list column with names. They both seem to be unreliable because the "modify by" column type changes when the line moves from the working sheet to the archive sheet and the drop down list column isn't always filled in by the associate.

Is there a way to automatically generate the name of the person who completed an item? My current automation moves a line from the open list to the closed list when a box is checked.


Best Answer

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    Answer ✓


    I don't think there's a way to do this automatically, and I have looked!

    You could use a workflow that sends an update request to the "modified by" user when the status changes to complete (or whatever your criteria is.) Include a drop down list column where they can select their name. This way they are at least getting a system prompt to fill that in.


    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!