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.
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…
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…
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…
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
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…
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 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.
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…
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…
