-
Alerting when a new line is added to a report
Hi folks! We have our product roadmap that is being accumulated from 200+ different smartsheet for the different product development teams. My job is to build a technical support training curriculum for the new features that are being deployed so we can better serve our customers. I created a report that accumulated all…
-
Syncing cells across sheets.
I have a process where I have multiple users entering data into their own individual sheets. I want copy from those multiple sheets into a single master sheet. I also want to update the master sheet cells any time a cell is updated from the individual sheets. I have been able to get this working, but the linking process is…
-
Populating Entire Columns Referencing Another Sheet
Hi all! Over the last week or so I have been trying to build a report that shows average tasks completed over a given 12 week period. So far I have been successful in creating the formulas for these, which have been working on dummy data. Now I would like to process live data from another sheet. Well ideally I would…
-
Formula to find the average word used in a column
Hi, Is there a formula I can use to find the average "word" used in a column? For example, I want to find the average of these words from the drop-down list: Cheers! Ann
-
Dependency with Teamworks
Hello! I'm new to Smartsheet and trying my best to learn so please be patient with me. We are a small company and are starting to properly organize our team using Smartsheet and TeamWork but we're running into a wall. My boss found out that if you link TeamWork together they both share co-dependence meaning that if you…
-
Copying specific rows when specific dates are reached
I have built out multiple schedules on smartsheet for a couple of different departments. I'd like to copy all the rows of the different sheets for all the employees working that day to a centralized sheet. Then after 24 hours, the sheet gets wiped and it starts over. I'm looking through the workflows and I'm not quite sure…
-
I am trying to set an automation to trigger a daily email when a value in a cell is equal to 1.
I have the automation set up to trigger an email when the value changes from 0 to 1 but I also want to be sending a daily email if the value is 1 and does not change.
-
How do I set up my sheet to reflect changes made in another sheet?
Hello! I am new to Smartsheet and trying to figure out how (and if it's possible) to set up a workflow or formula to reflect changes made in another sheet. Currently, I have one sheet set up that's linked to an intake form. I am using this sheet as a "master sheet" to track all submissions. Additionally, within this master…
-
How to send out an alert when a row hasn't been updated by a certain time?
Maybe somebody else has run into my issue and found a creative and automatic solution. My setup is as follows: 1) I have a sheet where I capture the project status from 10+ team members. 2) It contains a 'Modified' column. 3) The sheet contains calculations that are updated whenever the sheet is being opened (e.g % of time…
-
Move Row Automation lagging terribly
I'm leapfrogging rows from a form collection sheet to an intermediate sheet, and that move row automation works fine. From the intermediate sheet, I'm moving rows to the main data sheet. This is where things are lagging, like stopping for multiple hours for no reason. The rows that are moving have only 5 columns. There's…
