-
Some parts of the automation not running based on Index(Match) cell change
Hi folks, Could I get some help with this issue, please? Published sheets shared below. Workflow: Order Form Sheet - lists items (Primary column), has a Submit check box column (box is checked), and has a status dropdown column with an INDEX(MATCH) formula referencing the Tracking Sheet. Rows are locked. Tracking Sheet -…
-
I need something different than the update request
I use Smartsheet to process requests and want to be able to send back a message, some information in columns and an attachment. I use update request, but don't really need an update. I also wish the message box was a little easier to work with. It's pretty small and I usually have to scroll to type in a complete message.…
-
Merged: Rich Text Formatting in Automations & Forms
This discussion has been merged.
-
Merged: Allow editable formatting in automated emails
This discussion has been merged.
-
Fomulas and automation
Hi Everyone. I have a rag status column on my Smartsheet which is determined by a formula, so as the task becomes due or overdue the rag status updates from green→amber→red. I'd like to receive a notification as tasks transition to amber/red. I created an automation, based on the change of rag status, but it only triggers…
-
IDEA: Populate Available Field Names After Typing Double Curly Brackets {{
When I create custom messages in Automations, such as approval emails, I'd LOVE to have the system give me a list of possible field names to use after I type in the double curly brackets '{{' This would work exactly like Dropdown lists do, with their pre-populated lists.. I'm certain there are other locations where this…
-
Can you re-trigger an approval workflow?
I have a couple different scenarios that I've run into. The first is that the end user is saying that the approval request isn't coming to them, so they can't approve anything. The second scenario is that the approval goes to a person that they wrongly identified and we need to re-route the approval to the appropriate…
-
Merged: Automation Copy and apply to new sheet
This discussion has been merged.
-
Copy row automation broke after ownership move
Hey! This automation was working fine - but now that I've ensured that as i look to leave the company we have better owners, i can't select this sheet. They're in 2 workspaces, which wasn't a problem before, it had been functional, and i'm still admin/owner level in both locations. I promoted the owner of the source sheet…
-
Automation being triggered whenever anything in my row changes, not just the field I specified?
Hi there, I am having trouble with an automation workflow in Smartsheet, and I am not sure why it is happening. I had this same workflow set up on a different sheet (an older version of our database) and it worked just fine. I'm driving myself crazy trying to figure out why it's not working now. Basically the automation…