-
Is there a way to set up automated reminders for just specific columns in a sheet?
I'm working on a sheet that has lots of columns, so want to create an automation to remind people to only update specific columns on a biweekly basis. Is this possible?
-
Any ideas on automatically creating workscope packages base on changed rows?
I have a large database that users can make changes to, those changes are then put into a workscope for processing. I don't think I want to use the highlight changes feature, because sometimes the changes may stay in limbo before processing for more than a month or two, and I don't want to use show changes since I last…
-
Forms - "Open-access" approval option?
Hello! I've created a form that we are using for eTimecards. (Working with a pilot group now) Currently have the person entering the form also entering their approver's email (approval flow routes to this person as an update to add additional details and approve/deny triggering the next flow) My initial thought was that it…
-
"Copy Row" Automation workflow creates duplicates in final sheet
I have one sheet where we catalog all the estimates that we do. Each row is an estimate and there's a column that has the contractor for that job. I made a workflow where this sheet copies each row that is marked with a specific contractor and sends that copy to another sheet I made to catalog that specific contractor's…
-
cannot edit existing automated workflows
I am trying to edit some existing workflows and when I click the edit button nothing happens I can still create new ones if use the templates but when I click create from scratch nothing happens as well... it was working fine yesterday, any one got the same issue or I am dealing with an isolated case here?
-
How can I use a cell value as the To: email address in an "Alert Someone" action
I searched the community and likely I am not asking this question correctly as I cannot find an answer. Background: I have a master worksheet with one row for each project. For each project I keep track of the person submitting a project request by saving their email address in a "Submitted by" column. Requirement: I want…
-
Resubscribe to workflow
Hi. I had 2 outside users accidentally unsubscribe to an automated workflow. How can I resubscribe them so they can receive the automated emails again? Below is the screen shot of the workflow properties
-
Large Dropdown List Search
Hello- This would be great- a way for Smartsheet to search all words and numbers in the drop down list, not just the beginning of each option. For example, I have a very long list of hospitals that start with the site number followed by the site name: 301 ABC Hospital. This isn't convenient at all if the person (most…
-
Replacing Cells when row is moved to another sheet?
Here you will see my columns, and my archive (2nd sheet) is the same, i have an automation that basically says when the next recurring date has populated and it is -2 days old to move that over to my main sheet, and that is working for me. My question is, is there an automation or a formula where when it is moved back to…
-
Update Request Workflow - with dropdown options
Hello Is there a way to include a drop down functionality in an update request workflow. I have a sheet to track defects in products made in the workshop. We have 4 production departments so the first question is "which department caused the error ?" then depending on if it was department A, B, C or D this should flow to…