-
Removing duplicate rows in a sheet
Would love to see a feature to remove duplicate rows in a sheet. I have an automated rule setup to move rows into a sheet every day and some of the rows are duplicates. I would like to automate the process of removing those duplicate rows.
-
Best method for linking 2 sets of data together that use forms to collate the information?
I'm working on a project to help devise a solution to track all of our organisation's skills & talent initiatives, plus that will provide us with some useful metrics. The plan is have 2 forms - part 1 that collates all of the schemes' information and then a part 2 that collates information on outputs, but which is sent…
-
Merged: Automation of Copying Rows
This discussion has been merged.
-
Automation spanning multiple sheets
Current organization: within a single folder, there are about 10 sheets, each for a different project. The same Assignee will be present in multiple sheets. I want an automation that will send a daily email to each Assignee listing all of their open tasks (i.e. start date has been met). I can do this for each individual…
-
Can I have ONE automation for approval requests go out, rather than one for each line?
A have a sheet that has multiple lines for each form entry. These entries need to be approved, but come onto the sheet as pending. At the end of the month, I want an automation to go out to let people know that they need to approve any pending tasks. However, when I did this, it sent off SO many emails, one for each line.…
-
Automate Date Fields
I have reoccurring tasks that have start dates and end dates. What I would like to do is after the status changes to completed, then automatically change the date fields to the next occurrence. For example: I have a task that has a start date of 7/1/25 and an end date of 7/10/25, and that task reoccurs quarterly. Is there…
-
Merged: Replicate rows based on cell value identified in form submission
This discussion has been merged.
-
Smartsheet 201 - How to Build Reports and Dashboards - Free Smartsheet Webinar
I wanted to share an exciting opportunity to level up your Smartsheet skills! Tomorrow, our Customer Success team at DigitalRadius is hosting Smartsheet 201: How to Build Reports and Dashboards, a free webinar designed to help you create powerful reports and dashboards to enhance visibility and collaboration. We already…
-
Merged: Set up Automation to physical send out attachments when files are shared.
This discussion has been merged.
-
Personal Automation Templates
Having to create complex automation from scratch in multiple sheets is very time-consuming and leaves significant room for error. Having a "create a template" option that can be used over and over again would be incredibly helpful. Logged in user defaults can be used for who is to be notified in the template; however,…