Record an Approver Name once Approved using Automation
I am looking for a solution to record the name of the approver when using Approval Request automation. I can see there have been few questions/discussions on this, but can someone point me to the solutions - without using Zapier :)
For example, a request to approve a report is being sent to John, Jack and Jerry. Jerry approves it. I would like Jerry's name to be automatically stored in one of the columns.
- John / Jack and Jerry do not have access to Smartsheet nor the sheet.
- Cant use automation as the column will be updated as automation.
- Column will be locked for future audit purpose. I can do this by using Lock automation.
Any ideas folks?