-
How do I copy a HWO to different Smartsheets once a checkbox is checked?
Hi all, I am looking to build out functionality that copies a HWO to multiple Smartsheets once a checkbox is checked. Is there a way to do this without cell linking or copying the full row? Thanks, Jenn
-
Reminders
If a column status shows as Submitted from another column for the approver, is a reminder able to be set via the automation set up?
-
Cloning Automated Workflows Across Sheets
Is there any way to clone/ copy an automated workflow from one sheet to multiple other sheets without having to recreate it manually in each sheet?
-
Ensuring Automation Alerts Stay in One E-mail Thread
Hi, We created a variety of automation alerts for our business development team to receive alerts related to the progression of a specific patient through the referral process. Ideally, we would like for the e-mails regarding the same patient to remain in one e-mail thread for organization purposes. I set the subject line…
-
Is there a way to have a flag automatically turn red if a Priority column is "A"?
-
Copying and Unlinking Cell Data
Good morning, I have a master list of all of our projects comprised of linked cells from our project schedules -- so it updates as the projects update, providing a summary status overview of the percent complete on all projects. I want to track our progress month-to-month to determine how much progress was made during a…
-
Automation 'Copy to another sheet' doesn't work
I have set up an automation rule to, when triggered, copy rows to another sheet. My trigger is a certain field that changes from 0 to 1. I've tried a couple of times and non of my rows are copied. To test it, I added to the same automation rule to not only copy my rows, but also send me a notification when this field…
-
Formula for showing subtraction/sum compared to total
Hi there, I'm working on testing quality assurance of products sent to my company. For each row in my Smartsheet represents one product I am testing. Each row requires testing on 160 samples. In my reports I want to show the "Result Summary" column where if there were no nonconformities, then it would show up as "160/160".…
-
Row Copy Automation
I have two sheets - a Checkpoint sheet and a project RAID log. If Action Required is set to YES on the checkpoint sheet, the copy row automation should trigger to copy the row from the checkpoint sheet to the project RAID log. I have hidden columns in both sheets so that they match but only the relevant columns are shown…
-
Can I create automated survey feedback to a user in Smartsheet
I'm new to using Smartsheet and I'm trying to design a survey with automated feedback to the user. I'm wondering if Smartsheet has the capability to do this. Here is an overview of what I'm trying to do. I have created a survey that will be going to out to certain company branches. The survey has 10 sections with a pass/no…