Sheet Help

zlogan

Hello everyone, I am not sure if this is possible but I am trying to manage a project that involves multiple color approvals for a singular item but lots of different items within the project. Can someone take a look at the attachment and tell me if something like this is possible? I understand the basics of the notifications, its the other stuff I have no idea about.

Screenshot 2024-12-02 at 4.31.41 PM.png

ChristianFinke

Yes, your project workflow can be managed in Smartsheet. You can create a sheet with columns for each item, its associated color approvals (checkboxes), and the product name. Use automation to trigger notifications. For instance, when all color approval checkboxes are marked, a workflow can notify the responsible person to add the product name. Another workflow can send a notification once the product name is entered. You can also use formulas to track approval status (e.g., all colors approved) and conditional formatting for visual cues. This setup streamlines approvals and notifications effectively. Let me know if you'd like help!