Approval flow status - need help
Hello, I am in the process of creating a sheet (two separate forms depending on requesting line of business). My team handles one operation while my peer handles another. I have the automation when forms for specific lines of business it will send our respective teams an update will be sent via email. I also have a hidden box within the form of who the approvers are for said forms so it fills in on the sheet. Is there a way to get a formula or automation to autofill who is approving said request when they adjust the status? I created the 'request fulfilled by' column to hopefully track who approved of the request, I already tried 'modified by' but continues to be automation@smartsheet.com since automations are active.
Thank you!
Answers
-
Hi @bsaucedo
If I understand you correctly, you're trying to get the email address of the actual approver to be auto populated. Smartsheet doesn't have this feature yet. The only way you will be able to find out will be through the cell history option in the Approval column.
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
-
Hi @bsaucedo
I hope you're well and safe!
This might help.
Please have a look at my post below with a method I developed.
More info:
Would that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå @AravindGP Sorry I should have specified, I want it to essentially auto-fill the 'who fulfilled the request' column based on who adjusts the status to approved or denied (whether that is in the sheet or via the email our teams get). Our teams are fairly small, there are three of us on my team and two people on my peer's team that could potentially do the requests. I thought having a contacts column with a column formula or automation would be a easy fix to my concern but I don't know how to do it. There is an automated email that goes out to the requestor to let them know their requests status so I would like to include the 'approvers name or email' in case they need to follow up.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!