-
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…
-
How can we have a drop down in Dashboard
Hi Team, How can we have a drop down in Dashboard My objective is - Say for a example a user want to see just the input related to his/her project he can filter his project from dashboard and view. Thanks
-
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…
-
Automation Row Transfer - Not showing on the destination sheet
Hello, I set up an automation where when a certain field is fulfilled, it moves the entire row to another sheet. The automation moved the row off my sheet, however, it isn't showing up on the sheet where it's supposed to transfer onto.
