-
How to request update only for certain people?
Hello, I am making a ticket tracker sheet and am not able to figure out this road bump. I have a sheet where there is "additional information" column. When i type in that cell I have it automated to where it will be sent back to the requestor with the "Request and Update" email option where they can then type in the…
-
Enable File Handling in Bridge
Make it possible for Bridge to hand files as variables and results from actions. The example being a SharePoint API call returns a file that will then exist in the reference data of that complete action. This file/reference could then be used in future actions such as another API. My scenario required the use of the…
-
Set Workflow to a specific cell/row not the column
Hi! I'm trying to set up an automatic workflow that will trigger an email alert to a person when a particular cell has been populated but can only seem to be able to do it for a column and not a specific row. Example is: Person A is assigned a client. When Person A completes Task 1, Person B is to Peer Review that…
-
Email Notification : How to Remove the "Personal Email" on the "Changes made by" details
I saw that there were recent updates regarding email notification we set up through Automation. We can now choose "Send from Smartsheet Automation" and "Send from my organization". Currently using the option "Send from my organization" and then the messages includes "Links to sheet and specific fields" option on the "Alert…
-
Email Notification : Removing the "Personal Email" on the "Changes made by" details
I saw that there were recent updates regarding email notification we set up through Automation. We can now choose "Send from Smartsheet Automation" and "Send from my organization". Currently using the option "Send from my organization" and then the messages includes "Links to sheet and specific fields" option on the "Alert…
-
Automation to move rows stopped working
I have an automation setup to move a row to another sheet when the status us changed to "Complete". This automation was working fine until I upgraded from Business to Enterprise. Now the automation does not trigger automatically, and when I trigger it manually it moves all rows from the source sheet to the destination…
-
Managing fields displayed in an automated update email - placeholders?
I need to create an automated update message that will be sent to executive leadership. The message contains three columns from eight rows on my project sheet and has a link embedded to the published sheet. (See below) I need to remove the link automatically inserted at the top of the message. I tried placeholders (which I…
-
New proof info columns and automation enhancements!
Hi Community! Have you ever wanted to automate the proofing process or have more insight into who’s approving or requiring changes? Us too! With this release, you’ll be able to track each person who has voted ‘Approved’ or ‘Changes Needed’ on a proof, as well as each person who hasn't yet voted. This enables you to stay on…
-
The smallest date with a specific status in the child cell
Hello community, I hope this message finds you well. I need a formula to classify as TRUE if my row has a "Not Started" status and presents the smallest start date within the cells, which in the example figure, are filled in white. However, I couldn't come up with an efficient result. Any tips or help to build this formula…
-
Non-repeating email notification when value in sheet is reached.
Hi all, We have an automation set up to send an email for when a certain value in a cell reaches 50%, 75% and 100% of a predetermined value. For example, the automation will fire when the cell value is 10 of the predetermined value of 20 (50%). Our issue is that the notification fires off again every time the cell value…