-
Copy row automation errors - does it reset?
I have automations setup to copy completed tasks to a separate sheet. When the sheet fills up and can not accept more data i received a notification that these automations cant run. So i went into the sheet and deleted or moved rows to additional sheets as needed for my processing. This freed up the sheet to accept more…
-
Alert Someone Notification Not Working
I have set up an "alert someone" notification that is not working. I have edited, deleted, deactivated and re-activated it with no solution. I set up a two sheets around the same time, one works and the other doesn't.
-
Export only new rows from form submissions to excel
I have been searching for an automated way to get this done. I have a pretty intense (for me personally) form that my coworkers use to track a number of things that I measure. I am pretty married to my sheet and have a number of automated workflows running with it as well. There are about 48 columns of data including index…
-
ALERT SOMEONE
I am having problem to setup automation to alert someone. I have a column that shows 4 rows and another column that shows when the Alert someone should be sent out: Citrix/Network/PC Comm 1 - 3 weeks [column Communication Released Date: 02/17/22] =PARENT([Network Migration Date]@row) - 21 Citrix/Network/PC Comm 2 - 2 weeks…
-
Moving rows/updating cells
I manage a portfolio of projects which I have to report on. I'm a Pro user, so I don't have the functionality that could probably make this task very easy. My project managers are required to use a company solution (not smart sheet to create project plans and updates). I've created a smart sheet that lists all of the…
-
Data transformation during Excel Import
Dear SS community, I'm exploring the use of Smartsheet for payroll whereby I import 3-4 different and formatted Excel files to SS. The challenge: the excel files are formatted (think merged columns, etc) and aren't easily convertible to a .csv. Currently, I have multiple excel macros that strip formatting and walk…
-
Automation before Calculation (Dynamic View)
Based on testing, automation is happening before cross reference calculation has completed. Rows are added through Dynamic View (DV). After a new row was added through DV, the calculated field (cross reference) was #INVALID. After 1-3 seconds it appeared correctly. Creating a new row directly on the sheet calculated faster…
-
Automated Alerts - Comments
In an approval workflow when someone is notified on the Approved/Declined status, we have built a "message only" alert back to the user who submitted the request. The user will never be shared to the sheet and so the option to include a link to the sheet with selected columns included is not an option. Is there a way to…
-
Problem with Automation - Conditional Path
I have automation set up to work off a checkbox column. When I check the box, I want four separate emails to go out to four separate groups. Each group's email provides a distinct link specific to them. The automation is set up for "message only" - no links to the sheet or specific fields. The automation permissions are…
-
Why do my automation rules take 1-3 minutes to update when trigger is "when triggered"
I have been trying to create several automations that simply update a field based on the data in another field. Example is when Status = Complete, update % Complete to 100%. OR When status = Complete update a comment in the comments field. No matter what rule I create, it takes upwards of 3 minutes for the changed cell to…