-
I need to autoassign review of documents from a list of engineers
How can autoassign a document to be reviewed by an enginner in a list of N enginners and avoid to assign a document to the people who is requesting the revision, is that possible? I have a sheet like this (other columns): Requester Assigned to and other sheet with the list of the engineers. Hope anyone can help me.
-
How to send an alert when a ticket is reassigned.
I 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 to.. and I select all possible assignees from the available list. Right now, the alert…
-
Secondary Notification Automation -
I 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: Someone in Austin, TX completes the from - John gets notified. My quandry: If John does…
-
if formula help
I am trying to do a formula that states: if there is text in the column2 then place a "1" in the primary column. @Paul Newcome
-
Copy , move or share selected cells / information with others
Hi 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 Im doing it with trick like to send to landing sheet with some automated actions to…
-
Form row count alert
I 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 rows if all the sessions get full. I want to try and get an alert for when each…
-
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…