-
#NO MATCH due to Smartsheet bug
I received this message after submitting a ticket to Smartsheet. As there seems to be no end in sight I'm curious if anyone else is having the issue and if they have found any solutions to resolve it? ---------------- I'm from the Escalations team here at Smartsheet Support. I was looped in explaining that you are seeing…
-
Workflow: Repeat Email Address Instances
I have a column where there are 20+ instances of the same email address. If I create a workflow which sends an alert to all contacts in that column, will it send the alert 20+ times to the same email address? Or does SmartSheet have a failsafe which will only send the alert to that email once?
-
Multiple approvers simultaneously
I am trying to create a workflow that allows form responses to be sent to multiple people to approve at the same time. Currently, how I have it set up, there is only one approval cell available, which means that only one person can truly approve the form responses. I am wondering if there's a way to add multiple cell boxes…
-
Combining rows with like names
We have a sheet set up with forms to allow for participants of a contest to #1 register for the contest, then #2 go to the second form to update their progress in the contest. Is there a way to combine rows when a someone submits the same name or email address, for easier tracking? Something that is automated to create…
-
Copy Row Automation
Hello! I have been tasked by my team's leadership to create a way that they can audit how often my colleagues are updating their project plans. We currently have a "Master Sheet" that lists all of our current projects and certain cells linked in from each project plan. The project manager is supposed to be updating their…
-
New Workflow Already Met Condition
Hello, I have a workflow that I just added and the cell to trigger the workflow already met the condition trigger so the email should be sent however I tested that and email not going through unless I do it manually. The reason is the cell status already has the trigger word. Is there a way to trigger the condition to send…
-
How do I automate copying a subset of fields/columns to another sheet when criterion is met?
Hi, I built a request form with several fields. The requests will then be reviewed and either approved or rejected. Is it possible to build an automation that copies data in some fields/columns to another sheet only if the request is approved?
-
Workflow not working
I've set up an automated workflow and can see that it has "ran" however, email alerts are not being received. Have tried several tests with no success. Have also checked everything I can think of setting wise and a bit lost on this one, considering I've had success with similar workflows.
-
Workflow Runs but appears not to recognise condition
Hi I created a Sheet that continuously counts the time to a monthly meeting (4th Wed of the Month). The sheet has been checked and gets the correct date and interval. I use this date to calculate the interval / days to next meeting with a formula =[4th Wednesday of the Month]6 - TODAY() in a Column titled "Meeting…
-
Copying a value from one column to another when triggered
Hello - I have a sheet that has a project start date column and an end date column. When the project is approved, I would like those dates to be copied into another column (as "start date" - "end date"), or if necessary, a two columns (one for each of the dates). Once the dates are copied, I do not want them to update…