-
Add date to formula
Hi I am currently using this formula =SUMIFS([Number of Slides]:[Number of Slides], Done:Done, 0, Status:Status, "Handed to Pathologist") I want to look at the date for the next 30 days. I have a column titled "Due Date" with dates (2/20/2021) in them. I want the total number of slides in the next 30 days. Could you please…
-
Automation for more than 1 Row
Hello, I really like the automation that Smartsheet brings, especially now you can use place holders for the Column Headings and send messages now. However, with the tasks that we do, sometimes an automation will be for a number of rows, not just for a single row. When the automation is sent, it seems to collaborate the…
-
How to add date to formula.
Hi so I am using this formula =SUMIFS([Number of Slides]:[Number of Slides], Done:Done, 0, Status:Status, "Not Started"). I want to also only filter by a certain date. how do I add that. There is another column called "due date" and there are dates in it. How do I only look at stuff due this month by adding it to the…
-
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…
