-
Basic Automation flows not working
I cannot for the life of me figure out why the most basic automation tasks are not working. I have checked my permissions and I should be getting notifications, but my workflow seems to work very sporadically. I want the email to be sent to the PM when the "helper box" column is checked just so I can see what the email…
-
Flag or Conditional Formatting?
I want a way to 'flag' a cell if it is out of range of two other cell dates. I haven't been able how to do that with conditional formatting because I can't set a condition to say if "this column" is NOT between "this column" and "this column" (where the dates change for each row). Is there a way to do that? I thought I had…
-
Making mandatory an update request in automation workflow
I would like to know if in an automation workflow is it possible to make it mandatory to modify or change a column data or field in the request before making it complete. I have set a Field of the status of Our customers, and in a certain moments I need our sales team to update some columns,... I did a workflow to send…
-
Automating Status of "Completed"
I want to be able to have all tasks with a status of "completed" moved to the bottom of my parent section. I don't want to move to another sheet, but instead to the bottom of the parent. Is there a way to do this? Formula / Automation? Thanks in advance! -mc
-
Has anyone successfully triggered an alert using only a checkbox as the requirement?
I created an alert to trigger when a check box is "Checked," however, the alert has still not arrived in my email, including the spam folder. I wanted this to print out a request for our working files without manually creating an "Update Request" each time I need one. I have tried the trigger as both "When rows are…
-
Can a Smartsheet form populate a PDF, and then send that PDF to Slack
Hi My company has a logistics driver that delivers sets to theatre. He usually fills in a paper form of what he has dropped off and then takes a picture of that and posts it on Slack. We have decided to move over to a paperless system and have made a smartsheet form to track which sets are delivered. Each time a new row is…
-
Automate: Assigned to
Hi, We have just started to use Smartsheet in our organization, and for each week we are onboarding new team members to our workspace. Is it possible automate the contact list that we use in the column Assigned to, so its in sync with the people that are in the Workspace? Now I have to manually go into every project and…
-
Can Smartsheet lock a column AFTER data is input, for referencing in Update Requests?
Hi, I have a Smartsheet workflow I would like to implement and can't seem to figure out if it's possible. I have a sheet with four columns: Name, Date (formula set to the following Monday after the CreatedBy date), Commitment Detail (a work task they are promising to get done), and a Commitment Completed (yes/no dropdown)…
-
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.