Background
We create and approve purchase orders via Smartsheet. On receipt of the invoice to the accounts team the named approver (Contact List column) for the PO is sent an update request with the attached invoice and the field "invoice approved". They review and check the box, submitting the update. There are 12 invoice approved fields per PO, as some PO will have up 1 PO a month.
The sheet is locked down - most people have "view" access and create a new PO via Forms, those auth'd to approve invoices have "editor" access with most columns locked to prevent them changing, e.g. amount. The accounts team are sheet "admins"
We would like to open the sheet up so anyone can be an editor, add comments, attach invoices etc, but we have to either restrict some fields or preferably easily see who last updated them.
So, whilst we can use View History to see who checked the invoice approved box, the accounts team would rather see that information displayed in a column, e.g. "invoice 1 approved by"
Request
Can we do that now? how?
If not, could there by a column type of formula that can display Last Modified By for a specific column.
Thank you