VLOOKUP Reference Vacation Calendar to Update Approver via Automated Workflow
Hi, I have an employee Vacation Planner sheet with a status column/formula that indicates whether an individual is currently on "PTO" based on today's date and whether it falls in the range of their vacation's start and end date.
In a separate Smartsheet, we will be managing service tickets and certain types of requests require approval for which I've set up automated approval workflows. I would like this "Service Ticket" sheet to reference the Vacation Planner sheet to match the "Approval 1 Contact" against the "Name" in the Vacation Planner column and return the "PTO" value from the Vacation Planner Status column to the "Approval 1 Out of Office" column IF the status column is showing "PTO". "Approval 1 Out of Office" should be blank if no "PTO" in Status. If "PTO" returns, the workflow will push to the back-up approver.
Having difficulty with the formula and appreciate any help.
Service Ticket Tracker:
Help Article Resources
Check out the Formula Handbook template!