-
Rows could not be added to the destination sheet because it did not have enough cells remaining
I have a blank sheet that serves as a "backup" for our main sheet. We have an automation that copies the data from the source sheet to the to the backup sheet once a week. To work around the fact that smartsheet doesn't have a built in way to delete data, we also have a blank excel file that "uploads" to the backup sheet…
-
Is it possible to subtract a duration from a date which drives the start date
What I am trying to do is Helper - Duration = Actual start date. So, for example: 14Apr2026 - 22d = Actual start date. Is this possible? Note: I need to keep dependencies turned on.
-
Allow Mandatory (Required) Fields in Update Requests Triggered by Automation
Currently, when using Automation to send Update Requests, there is no way to enforce mandatory (required) fields for users completing the request. This creates data quality issues, as users can submit incomplete updates, even when certain fields are critical. Proposed Enhancement Add the ability to mark specific fields as…
-
Update Request Errors
Hi, We’re encountering errors when attempting to open an update request via email. Please see details below. Could you advise on the cause and next steps? Thanks
-
Updating template -> updates sheets made from the template
I would love to have the ability to make a change to a template that I created and be given the opportunity to select sheets that were created from that specific template to automatically update as well. For context: I keep track of ~130 employees training records. Each employee has their own separate sheet with all of the…
-
Automation: Ability to add a condition to workflow branching off from an unmet condition
Today in automation workflows you can only and conditions to flows that pass previous conditions. It would be helpful to be able to add conditions to the flows that stem from failing previous conditions. Scenario: I want automation to change the status of a task based on it's Target (completion) Date and it's Actual…
-
Copying, changing and moving row information
Have a samples request sheet that is populated by sales via a form. Once the shipment has been completed (triggered by date and tracking number input), the row is moved to an archive file and locked. Sales would like the ability to 'copy' previously archived rows, change dates (as well as automatically change the status,…
-
Status to red once the deadline is reached.
Hi everyone, I’m trying to automatically change the Status to red once the deadline is reached. I placed the following formula directly in the Status column: =IF([Ende]@row <= TODAY(), "Red", [Status]@row ) However, I keep getting the error #CIRCULAR REFERENCE. My understanding is that this happens because the formula is…
-
Sending a Notification not Working
I am still new to Smartsheet and I am trying to add automation to send a notification to a email account but it is not working. I have no restrictions on the project . Can someone help.
-
Is there a way to do an export of the automation workflows?
We have over 20 automation workflows setup on a worksheet. Is there a way to do an extract of these workflows to review rather than going one by one?
-
How do I display the username of a modifier of a specific column?
I am attempting to display the username of a specific column using an automation workflow. I want for a user to be able to scan a barcode into column A, and for their credentials and time/ date of the barcode scan to be displayed in the next two columns. However, I want the credentials and time to be displayed of the user…
-
Global/Regional Holidays feature
Dear Smartsheet Product Team, We would like to request enhancement to Resource Management (RM) to improve its functionality for global teams: Country-Specific Holidays Currently, any holiday added in RM applies to all resources company-wide, with no option to assign holidays to specific countries or groups. This limitation…
-
Tasks with multiple start and completed stages before FINAL completion
Hello! I'm building a sheet to track multiple tasks. Each task (FILE) has different stages of completion (PROCESS/INTAKE, Research, Drafting, Reviewing and Finalizing). Each stage has an ASSIGNED TO contact and COMPLETED date. The Finalizing date will be the FINAL/END date. We want to track turnaround time per ASSIGNED TO…
-
Dynamic View does not allow anyone to change and save specific column
I have a column with a dropdown list. The column is restricted to listed values, and you can select more than one. There is no logic assigned to that column in the dynamic view, and is not listed as required. I've tried disabling the conditional logic on the sheet, and it did not correct the issue. This is happening to…
-
Automation Where One Row Changes Other Rows
Hello Smartsheet Community! New admin here and I'm not sure if the answer to this question is simple or complex. Basically, I want to build an automation that when a top level row in the hierarchy changes Status (column) to "Complete", I want other rows to update their Status as well. My logic uses a hidden column Trigger,…
-
Reminder Automation
Hello everyone, I need help in this!!! I’m trying to set up an automation where a reminder is sent to the contact list 1–2 hours after a row is added to the sheet. Is this possible in Smartsheet? If so, could someone please help me with the setup? Thanks
-
How to complete a true Dynamic Linkage between Plans at the Milestone Level
I am looking to establish a dynamic link between two project plans. My goal is to surface milestone-level tasks from a Master Plan into a secondary sheet. Specifically, I need to ensure that updates to dates or status in the Master Plan are reflected in the secondary sheet, and I'm curious if Smartsheet can maintain or…
-
Date Based Automation Not Working
We have a sheet to help track when notary renewals are upcoming for staff and its a fairly simple process. We have a date column that lists the expiration date, a helper column that turns that into a total day count, status, and if an application was recvied. The trigger for this would be when that Days Until Expiration…
-
Symbol magically appears in a cell that is copied over to another sheet
I have a simple workflow that copies a row to another sheet. One cell is called a Job # and is populated with a number. When it copies over, the copied version has a symbol in front of the number. Example: '8282. I checked the original cell and no such symbol was accidently put in. Does anybody know what this is and what I…
-
Automation Not Working?
Hello, I have an approval path for update requests. It starts with a form, and it currently isn't being received after being handed off by the PCM. So, starting on page 3, the Area Director isn't receiving the update request. I have myself filled in for most of the steps which will be changed once I get this sorted, but…