Last Modified and Latest Comment fields for rows copied via workflow automation

Hello,

I have a workflow automation configured that copies a row from one sheet to another based on certain criteria.

Two of the columns that are copying based on this automation are the Last Modified and Latest Comment (AMAZING addition, btw) fields.

Over in the destination sheet, these two fields seem to retain their link to the source doc, and I can't figure out how to display the Last Modified date and the Latest Comment for the destination sheet instead.

Any ideas?

Tags:

Answers

  • Hi Eva,

    One easy way I would try to do would be to hide the said column and have another column added as "Last modified" and "Latest Comment".

    PS: Don't forget to change the name of the columns since it wont let you have same name for two different columns.

    Please do share if it works.