-
Conditional Repeating Routines
Hello SS Community: I'm a big fan of automation and something that would help a lot would be the possibility of conditional repeating routines (IF-THEN-ELSE) and using formulas using data from the worksheet, as part of an automation. This would allow sequential tasks to be performed, such as creating a certain number of…
-
What formula to use to add $ and comma in the field
I have a "run-rate" field that sums up values from 4 other cells. What formula can I add so the summed value automatically has the $ sign and comma between the numbers? Also, can I use the same formula in the other 4 cells so that people don't have to add $ and comma when inputting data? Thank you
-
Recurring Cleaning Schedule Setup
I'm helping my Laboratory Department setup a Tracker for a Cleaning Schedule that has a variety of pieces of equipment that each have a different time range of when they need to be cleaned (from every 2 weeks to 6 months). I had it in my head that I could use Gannt functions to setup the varying Durations of each piece…
-
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…