-
Any way to have a formula automatically change input when a set of new rows added?
Hi, trying to automate a process whereby the change from week to week on a project is reflected in a graphic on a dashboard. Right now, I have the source sheet for the data copy the rows to a separate sheet once a week. I want a formula to simply find the difference between last update and the new one. This is what will be…
-
How do I set an automation to trigger 3 days before a date in a column?
I have a column in a sheet called Install Date. I need to send out an automated message 3 days before the install date. Am I on the right track doing it this way? I think the first portion is what's throwing me off and my only options say that the trigger is for a date in the past or I have to set a specific date.
-
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…