-
Moving Parent and Child rows to other Sheets
Hi, Looking for some help moving rows to another sheet. We use one specific sheet to track ALL deliveries that come into our warehouse. A clerk in the warehouse makes a Form Entry for every group of items on the same packing slip, and attaches a photo of the packing slip for reference. Remotely, another clerk will read the…
-
Automated interactive Subject line and email / Update request
I love the the automated update/approval emails feature and i wonder if its possible the subject line can add more information with a code trigger from one of cells and not to have the exact same subject all time Also the sent to email to be triggered from contact email and not same email setup Thank you
-
Notification delay
I have a series of workflows set up for a form/sheet I am using. The process goes like this: 1. Someone submits form 2. Triggers approval email to be sent 3. If approved, this triggers an email to the requestor that their request has been approved. 4. This also triggers a different email notification to another email…
-
Automated Dashboard Metric Updates
Hello! I have a dashboard for one of my projects where I use a metric widget to share updates on each objective. I have an underlying sheet that sends out update requests every two weeks to the leaders of each objective. I have an automation within the sheet that archives old updates to an Archive sheet. I want the latest…
-
Convert form response in to standalone project?
Hi, I created a Smartsheet form to intake requests for support from my team. I'm not aware of an easy way to then create a project based off of the form response without having the Control Center add-on. Ideally I would like to set up a system where I can view the incoming requests then approve/reject/send back for more…
-
Static Date/Time Stamp
I've looked around and I realize that this is a feature many people want within smartsheet. I was wondering if anyone has a workaround for this. I want to automate the start date to today but I don't want it to change so using =TODAY () won't work. The sheet that I'm trying to implement this in also uses a form to input…
-
Automation Workflow - Moving Rows and Sending Messages
Hi all, I have set two workflows separately. I summary, when a status changes (2 possible values): Workflow A: alert specific people; Workflow B: move row to another sheet depending on the status change; Workflow A didn't go through whereas B worked as expected. Is workflow B preventing A of being run accordingly? Regards,
-
Automation - Cancel Update Request Based on Conditional Logic
Is there a method to use a workflow to cancel a pending update request? Let's say I have a user who receives an update request through a reoccurring workflow, and rather than use the Update Request form in the notification, they opt to edit the sheet directly. Even though they have fulfilled the function of the update…
-
Automation Workflow: Request an update
Hello Smart sheet hive mind! We're looking to send clients a "Request to edit" workflow from one of our sheets. I have a few questions regarding the Workflow, if anyone could help: When we send a request to edit, We noticed the row number that is requested shows up in the email. We don't want them to see the row number. I…
-
Automated RYG Based on % Complete Formula Help
Hi, I'm trying to automate the RYG colored balls so they automatically change colors based on the percent complete entered. I watched a video, read through the suggestions from the community, and was unable to come up with a formula that worked correctly. Can you please help me identify the error in my formula? When I…
