-
Automatically Add New Sheets to an Existing Report
Can new sheets be added to an existing report automatically? I am using Smartsheet as a project tracking tool. As I add new project schedules, I want those new schedules to feed an existing tasks assignment report. Can I do this?
-
Question regarding automations (triggers)
I have a question regarding triggers. Is it possible to create a trigger when you say cell C you have the year as 2025 and when that cell C says 2025 it triggers cell d to write the word active. When the 2025 is changed to 2026. there is a trigger to remove active so cell D is now blank. Thank you
-
Is there a way to send an email to a sheet and have it create a new row?
I am looking for a way if possible to create a rule in my outlook that could forward emails to a sheet and have them appear as new rows.
-
Improve Clarity Around Run Now Automation
Despite the text that tries to explain this, I don't think the current documentation for the Run Now feature is clear to new users. What isn't clear is that the Trigger and initial Filter condition are treated together and both will be ignored when using Run Now. Besides the help text description, the visuals for this…
-
Dropdown menu & how to separate results
I have a dropdown menu to select a choice of up to 19 out of a possible 42 items, each item selected needs to be separated into its own column as each selection is mapped. The way the mapping has been set up is the first selection in dropdown needs to be at position 1 even if it is the 4th option and the second selection…
-
Multi Contact Column with Automations
Hi all, I have a multi choice contact column that has a simple formula that looks at a country column and based on the country returns multiple emails per country, so lets say that column country is France i have the contact column return three contacts, so far it's fine but it doesn't work when i try to use an automation…
-
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…