I have a lookup list that I use to look up values that could change, i.e. when an approver leaves the company.
I have a 'Calculated Value' field that looks up an approver's email address from the look up list.
The calculated value field is connected to an 'ApproverEmail' column.
I, then, use this 'ApproverEmail' column value, which is passed on by the calculated field, when sending the email (I am not using quick approval because the approver needs to open the item and approve from there).
My question: What are the pros and cons of getting values from a lookup list using the above approach, as oppose to having a workflow doing the lookup?
Thank you for your input.