-
Rows that were un-highlighted before copy row workflow coming up highlighted on destination?
We have several individual sheets in which rows are highlighted and cleared during business hours. After business hours, each sheet has an automation that copies the days entries to a master sheet. Why, if the rows are no longer highlighted on the source sheet at the time of workflow run, are they appearing highlighted on…
-
New Window pop-up option
A recommendation I would like to make is adding a feature under widget behavior. When connecting a Smartsheet under widget behavior, it would be nice to have a check box or a toggle switch that asks if you would like a new window to pop-up whenever the widget is clicked. A new window pop-up is allowed if you copy and paste…
-
What does "in the next 45 days" mean in an automated workflow condition?
Hello, I am trying to figure out an automated workflow where the trigger is everyday at 8am and the condition is where a [Date Column] is in the next 45 days. I have many rows in the sheet that each have unique dates and emails to contact when 45 days prior to that date is reached. My question is: does "in the next 45…
-
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.