-
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…
-
Automation for missed daily log
I've got a sheet that is a daily log for the check of pool chemicals. We've set up some automation to trigger if the values drop or exceed certain thresholds. However would also like to trigger a notification if the frontline staff forget to record the daily readings. I tried trigger when a date is reached (Daily) and if…
-
Symbols and percentage of
I need your help to show status as Red, Green or Yellow using this criteria: Green - 91-100 Yellow - 51 - 90 Red = 0-50
-
Is there a way to see all recipients of an alert within the automated alert email?
I have created a Smartsheet which will sent automated alerts to multiple people. Everyone getting an alert is just seeing his/her name in 'to' but not the other names. So the person does not know who is informed as well. Is there a way to change it so that every recipient sees to whom the alert has been sent?