Hello!
I have an image production process sheet that at the moment requires 1-3 approvers per image. The images to be approved live in a cloud drive - they do not get attached to the Smartsheet.
Basically, when there is a contact email in an Approver cell, I need a formula to check what the Image Approval Status is.
Here is the flow -
- Vendor submits link, hits checkbox "Send for Review", automation sends an update request* to contacts in Approver 1, Approver 2, and Approver 3 cells. Approver 2 and Approver 3 might be blank if they are not needed. *This is not set in stone, was using this method so that they can also submit comments on what needs to be changed.
- Approver 1, Approver 2, and Approver 3 submit Update Request with "Approved" or "Changes Needed" along with comments in Approver 1 Comments, Approver 2 Comments, Approver 3 Comments.
Here's the logic:
Here's what the cells look like currently:
Different section of the sheet contains the Approver 1 - 3 contact columns:
Thanks for any help!
Heather