-
Adding email list for Automations
Hi All, I have a Drawings Sheet that I use to update contractors with up to date drawings, I send them a simple published URL but do not share the sheet with them. (See below) I use another Project Sheet to run the project and keep a status of the jobs. In this lists all the contractors with a Purchase Order for the works…
-
Backend Process for creating Workspace and Project Folder
Hello, Currently we create a new workspace for each projects even if that project has different Location, (ex. X Los Angeles, X New York, X Vegas) will have separate workspace. However, we want to create a one workspace for the same Project and have folder inside that for different location. So X will be the Workspace Name…
-
Why do the automated emails show from "my name" via Smartsheet"?
All forms, sheets, automated workflows, etc. show from "Amber Lange via Smartsheet". Is there a way to change this?
-
Count how many times a row is changed to get a percentage
Hello, My goal is to return a percentage of how many times we hit our deliver date the first time. I want to see how many times the deliver date is changed to get a percentage of how many times we hit the first deliver date we put in the field. So to do this I am having the sheet copy the row into a helper sheet and then I…
-
Syncing Smartsheet to Company Directory
Hi all I am working on a workflow and would like my Smartsheet to automatically notify a persons manager when something is entered. I cant figure out how (or if I can) get Smartsheet to sync with our employee directory. Thanks in advance!
-
Can you embed data on the back end of a Form to autofill selections?
I am building a form that will capture clock hours. Those employees clocking the hours are tied to name key, which is tied to a supervisor who is then tied to a budget center which is tied to a budget code. Is there a way to embed data on the back end to help auto-fill this information? For example: I select Jane Doe as my…
-
Is it possible to automate a formula across new sheets
In order to feed information into a dashboard, I am importing an excel sheet on a regular basis. Is there a way to have a formula automatically generate into each newly imported sheet, so that specific information is pulled into a metrics sheet? The formula would need to pull from the new sheet each time, but from the same…
-
Can I copy rows based on a formula updating?
Hi All - I'm working on new process, and have everything working except one small (seemingly) problem. I have two sheets that talk to each other, and they work fine. In Sheet 1, I have a status field (drop down), and in Sheet 2 there is corresponding Status field. When Sheet 1's Status field gets changed, Sheet 2's Status…
-
Populate contact cell with multiple email addresses for alerts?
I have investigated a few possibilities for this without success. Basically, I have a sheet of facilities with facility info. One of the items is what market that facility is in. So, If I want an alert to go to the entire market, I need to collect the email addresses for each facility that is in the market, then my…
-
Autogenerate Documents - One or more blocks in this workflow is invalid
I am trying to use the new autogenerate documents automation https://help.smartsheet.com/articles/2482492-build-workflow-automate-document-generation?ict_source=smartsheet&ict_medium=bulletin&ict_campaign=blt1229a When I test the workflow I get an email: One or more blocks in this workflow is invalid. Please edit the…
