-
Status Rollup Automation Becoming Invalid
I wanted to automate status rollups for parent rows. Via the forums I found this writeup (Solution to Automating Status Rollups - Quip) and followed it exactly. It worked great. Recently for some reason recently every time the "Auto Status Rollup 1" automation kicks in it ends up giving me the "A workflow has become…
-
Workflow Only Partially Working
Hi All, I am trying to troubleshoot my workflow to see what I may be doing wrong. I setup this workflow to send a reminder and then check off a box in a column after it sends. This issue is the reminder is going out but the box is not getting checked off. Attached is a screenshot of how I have the workflow setup. The…
-
Set Workflow to a specific cell/row not the column
Hi! I'm trying to set up an automatic workflow that will trigger an email alert to a person when a particular cell has been populated but can only seem to be able to do it for a column and not a specific row. Example is: Person A is assigned a client. When Person A completes Task 1, Person B is to Peer Review that…
-
Survey Results from Form to Dashboard Chart
Novice Smartsheet user here. I created a Likert-syle survey using a Smartsheet form that has about 20 questions on it. I have results from five respondents so far. I would like to present this data in a Dashboard using the chart widget - one chart per question. Ideally, the chart would show how many respondents answered…
-
Limitations with the custom message sent to the same user - Maximum repetitions allowed is only 6nos
The screenshots here shows the two scenarios that a recipient receives when a workflow is triggered from the Smartsheets Scenarios-1: The body message is not shown to the recipient if their name repeats more than 6 times/row items in the Smartsheet Grid. Scenario-2: The body message is shown to the recipient if their name…
-
Copy Column to another sheet
Is there any option to copy a specific column to another sheet after met the criteria (Workflow).
-
Restore deleted automated workflows
Hi Guys, i accidentally deleted an automated workflow (automation) created by an co-worker on a sheet. Is there any way to restore it? I already checked the activity log and see the creation and deletion of the workflow but no way to recover it. I am the owner of the sheet. Thank you in advance.
-
Default notifications when someone has been assigned to a row.
Is there a way to have smartsheet default to letting someone know that they have been assigned to a row? I know that you can set up an automation workflow to achieve this, but with the amount of projects we have going on across many different users, the chances of everyone going in to set up the automation and do it…
-
Dont trigger workflow on specific dates
Hello Community, im building a tool in which we input data from the last day every day. So i have a form in which workers are filling information about the yesterday shift. On Friday they are filling in it for thursday and on monday they are filling in the information of last friday. (And so on) The information is then…
-
Automated updates to multiple contacts
Good morning! I have a sheet that I am working on for voting on tool enhancement request. I currently have the sheet set up to request voting on 6 categories for a purposed update for our tool. The issue im running into is the update request is being sent to multiple contacts (for test purposes we are using 6 contacts),…
