How to capture approval "date" for multiple approvers
Hello!
Currently have automation built out for multiple approvers (potentially 3) per row, and my workflow functions correctly in advancing approval requests per criteria, but I cannot figure out how to add formula to capture date for each approval individually. Anyone know the proper format for formula to capture date from a cell?
I can only get the Modified Date@Row function to yield a date, but that is not each approver individually.
Any help would be greatly appreicated!
Answers
-
@Rayla you'll have to create a date column for each approver then a workflow automation triggered when the appropriate approval column changes to approved. The workflow would then record a date in the corresponding date approval column.
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives