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…
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…
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)…
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.
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…
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…
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
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…
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…
