What process should we use to automatically alert the contacts in that row about the status 3 days before the PP planned date?
Sometimes i would like to implement changes to a sheet that would trigger automations that i don't want being sent out. One such sheet has several dozen automations. Turning them all off, implementing my change, and turning all the automations back on, could be a faster process.
I am fairly new (yet familiar with the possibilities available) in Smartsheet. I am in the process of creating a tracking form for my job to see anytime a device is in use and which employee is in possession of a shared device and what location they are working at that moment. I am collecting the employee's name and ID…
Hi All - I am new to Smartsheets and I'm attempting to teach myself as I go. I created a sheet for every department that also has a form attached with specific questions to be answered. Department managers will use the form link provided to input their information daily. I am struggling with how to get these metrics to…
Hello, I am trying to implement an update process for our Staff Forecast Tracking Data Input sheet. For each project (grey rows), I would like to assign someone to update all the project staff's LOEs on a monthly basis. For example, an update request would go out to a specific staff member to update the 4/24 column of LOEs…
I want the user to see rows that are assigned to them only.
Hello, I'm having an issue importing email addresses from dataShuttle to a contact list, and using automation from this column. When I set up the automation triggers, it won't send to the emails in the contact list column, because it is saying it is a comment and there is an @email@org.com (just general example of what the…
Starting with the basic of, how do I populate from one sheet to another while adding a running total? The next layer to this is, how can I get different sub sections to specifically populate into another sheet. In my photo you'll see "Parent Node F" with a total footage in bold and a delta (Production Master). In the other…
I am trying to create an automation so that when the parent row is marked as complete, then the parent row and all of the children move to another sheet. I am just not able to figure out how to set the automation so that it ONLY moves if the parent row is selected and not the children rows. I did a formula so that if the…
Help please! A teammate turned on Resource Management on a critical sheet for our day to day operations. This seems to have trigged automation that archived all rows. While I can see the rows that were archived, I am reluctant to move them back without knowing How to identify the automation that was triggered in the first…