-
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…
-
Copy Rows
Good day, I am experiencing this problem, i am not to sure what it means - can someone please advise me what to do?
-
How to calculate time
Hi. What's the formula to calculating time? For example, in one cell, I have my starting point of 6:00am. And in another cell, I have a finish time of 11:00am. What's the formula to calculate time between these two points? Thanks in advance.
-
Automation to "Change Cell Value" to embed a formula into the cell
Trying to set an automation to "Change Cell Value" 2 columns involved: "BARCODE" and "PACKAGE UID/LOT #" If "PACKAGE UID/LOT #" is not blank, then I don't want to override the data in the cell, however, in the absence of data in that cell ("PACKAGE UID/LOT #" is blank), then duplicate the data from "BARCODE" into "PACKAGE…