Can Hello everyone,
Can someone please help me with this issue. We have sheet that is tracking some testing scripts and some of these rows have an attachment which is basically a sign off form. The ideal automation would be that when the script approval status turns to "Approved' the WF should check the filed that tells us if the sign of form is needed or not for that particular row. If the sign of form needed field says 'yes' the email is send out to the recipients saying the script is approved and also giving them the sign off form as an attachment in the same email to have them sign it.
Please note - attachments are already linked to that row that says sign off form is needed.
Please see below for my current WF -
- Trigger set to when rows are changed.
- Condition set to where 'Script requires a sign off' is 'yes' as not all scripts need that.
- Request an update selected with 'Specific fields' and have selected 'An Attachment' too.
P.S. I guess the photos are in a reverse order.
Please help me with this issue as I am stuck on it for 2 days. Thank you so much community!