-
Automate Trigger Slack DM's based on assignee email addresses in Smartsheet
It would be phenomenal if we could trigger messages to DM's or Ephemereal messages from Slackbot or the Smartsheet Slack App using some connection between the user's email in Smartsheet and the same email in Slack. This would allow users to be notified individually of changes or needs without having to alert the whole…
-
Trigger (Automate) an update request to go to a Slack Message
Our team uses Slack, and it would be great if we could trigger an update request that goes to one of our Slack channels. A link or button that is sent in a slack message to the channel that allows a user to fire the update request (similar to the email version) but without the "email" part would be PHENOMENAL.
-
I need a formula that allows the following:
If Modified B has “automation@smartsheet.com” then use Modified By column data but if Modified B is anything else place Modified B data in New Modified By column.
-
I need a formula that allows the following
If the Created By is Blank then insert the Create By data in the New Created By Column but if Created By is Not Blank then insert the Created By data into the New Created By column.
-
Workflow Automation changing cell contents
I have 2 'check' columns that indicate Start Confirmed and End Confirmed. I have 2 Workflow automations; When 'Start Actual Confirmed' is checked then 'Status' changes to 'In Progress'. When 'End Actual Confirmed' is checked then 'Status' changes to 'Complete' The issue I am running into is that when a user checks 'Start…
-
Delay automation trigger
Hello, Is there a way to change cell value after the request update entered? - what's happening is once this automation triggered, the cell value changed and that changed trigger another automation to send info to other people but the update has not opened yet for this request Does that make sense?
-
Do automations have an inactivity limit?
We realised that almost all of our automations, at random times, would freeze. We assumed due to no activity for over a month. Is that a thing? If so, is there a way to switch this feature off? I've only just been able to look into it and I don't see any time settings. I'm starting to suspect the reasons might have been…
-
How to make a form add a new row each time it is completed?
I have a form set up with an automated request every two weeks. However, after the first time a user has filled out the form, the next time they see it they see the data from the row they created last time. How can I make it so that each time a user completes a form it adds a row to the table? I'm tracking progress updates…
-
Need Help Automating Copy of Historical Values
Hello, I have a sheet that shows Annual Sales Forecast data in two columns - one column for current month forecast, one column for previous month forecast. I use those columns to calculate a third column to show variance from previous to current month. The current month column is pulling values from a separate sheet that…
-
I want a formula that specifies the lowest child of an ancestor, parent, child hierarchy.
I am using the Hierarchy formula, =COUNT(ANCESTORS()), to label my project tasks. A lot of the child tasks have tasks below that, going to a hierarchy of 5. I want to create metrics sheet that shows the estimated completion date for the lowest level child. Because the levels vary by task, I cannot choose a specific…