-
How can I automate a Dropdown list, so every value added to the column becomes an option?
Hello community, I'm new to Smartsheet and I'm struggling to find out how I can make every value added to my column to become automatically a option in the form dropdown list. Anyone knows how I can do that? Thanks
-
Request an update on specific fields based in a form with logic
Hello! I hope someone can help or provide any insight. We have implemented a sheet to review tickets using a smartsheet form. The tickets are categorized in 2 (lets say "Category A" and "Category B"), so each category has different options to review and the form has a logic depending on the category are the options…
-
Sending a single email to multiple people
Hi, I have several automations set up to email coworkers. However, usually I need everyone to be literally on the same email. I understand that ultimately smartsheets wants/thinks people are going into smartsheets to "work" but sometimes that's not the case, sometimes you have people outside your organization or whathave…
-
How to automatically generate a Date that's three weeks later than a given Date in another column?
I have a column named "Creation Date" (Date Type) and another one named "Response Due Date" (Date Type). The "Creation Date" is automatically recorded whenever a new row is added. How do i automatically set a date 3 weeks later in "Response Due Date" column. KEEP IN MIND PLEASE, that i already have 100 rows with manually…
-
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…
