-
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?
-
PICK CHART to determine Project viability
Hello, We are starting to use Pick charts to determine project feasibility and impact so that we only work on the most important things. It would be really great if a template set was set up with a project plan template like Template Set - Project Management Office where the template set would have a project submission…
-
Ability to run triggers on dates populated by the cell information more than once
Hi, When doing triggers for automation and when using the when this date is reached, if you want to have the trigger repeat every couple days you would need to set the date in manually instead of having it fill by a column date. It would be nice to have it be able have the trigger every couple of days ability for a date…
-
Smartsheet and Business Central integration
Hello All, I'm trying to integrate the Business Central projects table with the Smartsheet. I want to create a new project sheet in Smartsheet whenever a new project is added to the Business Central. However, it seems the Create a sheet option is not currently available with the PowerAutomate. Did anyone face the same…