Building a workflow for collaborative document

Hi All–I work in the food and beverage space where one of the things we struggle with the most is artwork/packaging creation. R&D, Quality, Regulatory, Marketing and Legal departments have to weigh in on artwork in two different phases: (1) Creation of a label brief and (2) Review/approval of artwork.

Label Brief - A document that captures important food packaging information as well as marketing claims. We work on a document in SharePoint so it’s version controlled, but don’t have a good mechanism to let people in the review process know when it’s there turn to review. Further, we would like to have a ready mechanism in where someone can “reject” and the document goes to a previous reviewer to make modifications.

Artwork Approval - After the label brief has been created/approved, the designer will create a draft document which needs to go through a sequential review as well. This is usually don’t by passing a PDF around by email with each team member “marking it up” with comments. We’d like to mirror a similar process to the label brief creation here and manage it with tasks and “approve”/“reject” logic. Is there any kind of workflow that might help here?

1 Like

Hi @bstanh,
I have kind of same need for approval workflow. In my case I want to distinguish between creator(s) and reviewer(s). I have setup some automation based on two status columns where the creator can choose “Pls review” status. The reviewer can use the other status column to push the document to bronze, silver or gold status and assign back to the reviewer (or declare it final). This works good except that you can’t restrict editing to a column based on a name in another column. See also this discussion: Help on setting up for Approval Process

Thanks for the response. I should have clarified the user roles we too would like to have–they’re very similar to yours. It’d be creator, reviewer, and approver. Are you happy with your current sequence?

Kind of happy. At this moment the only way to restrict column editing is by entering a “hard” name, I would love to see that you can restrict column editing to person(s) named in a person column. As entering a “hard” name is too much work for me I now have a situation the an editor (creator) can review her/his own document. I can share my workflow with you if you want.

I’d love to see the workflow, thank you!

I use 9 automations to move documents based on status and review status. I attache 3 screenshots:

  • the documents board itself
  • 2 screenshots with automations

If you can think of a better solution I love to hear :slight_smile:


@basdebruin This is awesome thanks for Sharing!