-
Unexpected Error Message
Hello - my sheet has a form that sends an automated email with a link to users populated in a dropdown via a checkbox. I've got a user who is receiving an "unable to determine your identity" error message when she clicks the link from the Smartsheet automated email. Does anyone know how to fix this to get my user access to…
-
Automation Question:
I did not see an Automation category. My sheet has a date field (Update Flag). This field gets updated with current date everytime a change to specific columns are done. The automation is set-up to look at that field and if it is "not in the last" 14 days send a message to the user in the "Owner" field. It works in one…
-
Provide a way to see the history of automations
It would be nice to see: all the triggering events of an automation all notifications and recipients of automated notifications version history of the automation configuration
-
Multiple cross references for one sheet?
Hi, here's the situation. Sheet A is a master list of employees with their title, supervisor etc. Sheet B has a column that is set up as a dropdown list of names of said employees. When I choose an employee on Sheet B I have it cross reference with Sheet A to pull the supervisor and some other information to fill in…
-
Send From Triggering User - not working
Hi, I have an automation set to "send from triggering user" for when any cell is added / changed that links to a sheet . I am the sheet owner . If a person called John Doe fills in the mentioned form from his logged in Smartsheet account , theoretically the automation should kick in, send out and notification email to the…
-
Automated Message from Triggering User
I set up several automations that result in an email being sent to a person after a form has been filled out by a particular user. That particular user should be the "triggering user" meaning when the email is sent, it should appear as though it comes from the person who filled out the form. Instead, though, the message…
-
How to generate an ID number, incrementing by 1 the last ID number created in previous row?
I have a sheet with already multiple rows created. I have a column with ID numbers for each row. I want to set up an automatic way to generate an ID number for all future rows added. For exemple, the last row created has an ID number of 2300. How to automatically generate an ID number of 2301 for a new row added?
-
Undo a automated workflow
Is there a easy way to undo a workflow. We need to delete emails sent to users via an automation. Can Smartsheet support assist with that?
-
Column Formula Alternative?
I have people entering information into a sample request sheet using form that allows the user to select multiple types of tests they would like to have run. The form populates "Sheet 1" and I'm using automations to create multiple lines on the destination "Sheet 2" using this solution: In the Source Sheet: Count of Rows:…
-
Can I add an attachment to an automation?
I want to specifically send out the same PDF file when an automation I have set up on the sheet is date triggered. However, I don't want to have to add that attachment to every single row. Is there way to do that without attaching the file to 1700 rows?