-
Proofs disappearing in some rows when transferred to another sheet
We have automation set up where when a task has been marked complete, it moves to another smartsheet for complete tasks. This helps keep our open tasks smartsheet uncluttered. I just noticed that some of our rows that have moved sheets have lost their all of their proofs. Based on complete dates, it looks like the issue…
-
Request an Update: Un-editable Text Box
Hi everyone, Looking for a little help with an issue that keeps occurring on multiple sheets. I am creating an 'update request' trigger, to send to contacts in my sheet to update several text box cells within a row. I am including several specific text box fields for them to update in my customized message. When my contact…
-
Automation Not Working
Hello, I'm at a loss. I've created several automation rules in the past and I cannot figure out why this is not working for me. I have a simple sheet with the following columns: Status (single select dropdown) Sub-Category (text) Task (text) Assignee (single contact column) The automation rule is triggered when the…
-
Add Column Description to Update Request
Include the column description when an update request goes out to provide some context to the column if it has a generic name.
-
Change Task Categories of other Cards when One Card is Updated
We have a lane that contains several services to be confirmed when a new client uses our product. There are multiple cards in that lane that need to move to other lanes based on the updating of the task category of one. For example, If a client says that they are going to use Product A, then we move it to a lane for our…
-
Multiple Step Automations
Hi All, I have a form that collects data. Once the form is submitted, it changes a field to "In for Approval". I then have multiple automations set-up to assign 7 different Owner based on certain criteria and 1 to send a request for approval to the newly assigned Owner. Most of the time this seems to be working correctly,…
-
big ideas for document generator
My team has 10-20 projects running at any given time in varying scale both in size and end user comfort with Smartsheet. We are (hopefully) transitioning our documentation processes away from clunky word docs into the more automated Google Docs direct from our project register as work requests come through. My first hope,…
-
Automating the Documentation of Historical Values without Workflows
Problem: How to automatically document historical values without using the automation workflow. I have a two-line graph of which one line (let's color it black) represents desired results within a date range. This date range ends in the future. The second line (let's color it red) represents actual results within the same…
-
Comments to appear in email notification for update request
We have set up an update request automation to include comments. However, when the email comes through, it does not show the comments and the only way to view them is to open the request. It would be nice to see the comments in the emailed notification prior to needing to open the request.
-
How to automatically update text every week?
Hello, So I have two columns: "Date Week Ending" that lists the last Saturday of each week and "Reference" that lists an X value. I want to have the X value appear for the PREVIOUS week ending date when my current week starts. For example, if today is 9/9 then I want the "X" value to appear for the week ending date of 9/7.…
