Automations
Discussion List
-
Copy parent row onlyIn Formulas and FunctionsI have automation set up to copy rows marked as "key deliverables" in my project schedule into a separate, key deliverables status tracking log. Unfortunately, when a key deliverables row in the schedule is a parent row -- i.e., …Answered - Pending Review 13 views 2 comments 0 points Most recent by John DeRoy Formulas and Functions
-
Secondary Notification Automation -In Using SmartsheetI have a request form built that will be released throughout our region. Based on which office location is selected, a designated person will receive a notification that a new line has been added to the sheet through the form. Example: …
-
Global Automation Permissions?In Formulas and FunctionsAre there global automation permissions, where the Limited option can be set across the board? All I could find was Permissions in Security & Controls. For any new sheet created, I want to default the Automation Permissions setting to …
-
How to send an alert when a ticket is reassigned.In Using SmartsheetI need the system to send out an alert when the 'Assigned To' contact list field changes to a value other than the current value. I have an Alert automation configured with a Trigger: When rows are changed. And When 'Assigned To' changes …
-
if formula helpIn Formulas and FunctionsI am trying to do a formula that states: if there is text in the column2 then place a "1" in the primary column. @Paul NewcomeAnswered - Pending Review 16 views 4 comments 0 points Most recent by Mike Wilday Formulas and Functions
-
Copy , move or share selected cells / information with othersIn Using SmartsheetHi All How to copy/move or to share rows to another sheet with column of my choice . or to share some cells / columns of my choices with others but not all row information The reason is i donot want to share some information with others…
-
Form row count alertIn Using SmartsheetI created a form for people to sign up for a class. I have 8 sessions available for the same class but with different dates and times. The maximum amount of attendees we can have per session is 150, so the sheet will end up having 1200 row…Answered - Pending Review 15 views 4 comments 0 points Most recent by Debbie Sawyer Using Smartsheet
-
Add date to formulaIn Formulas and FunctionsHi 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&quo…
-
Is it possible to remove the source sheet link from automated email notifications?In Using SmartsheetSeveral times a day I get requests to share a source sheet to a user who received an automated alert. Since the body text is small and the source sheet link if big and in a different color, i can understand why they are clicking on it. I h…Answered - Pending Review 161 views 11 comments 3 points Most recent by Andrée Starå Using Smartsheet
-
Averaging RGB ballsIn Formulas and FunctionsI'm hoping this is quite simple, but my simple mind is struggling to piece it together. I have a Parent Row with multiple Children but only one hierarchy below it and i want the parent row to average the status of the Red, Green and Blue …Answered - Pending Review 31 views 6 comments 0 points Most recent by Leibel S Formulas and Functions