-
Dropdown options for approval workflows
For the approval automations/workflows that send out emails to specific personel with the option to approve or decline a request, it would be super helpful if SS would allow users to provide a dropdown list of standard rejection reasons. I work on a team that when a new request comes to Finance we have a list of 5 reasons…
-
User doesn't receive workflow notifications
I´m trying to figure out why one user can't receive email notifications from smartsheet. Context: I have a smarthseet to track QA Auduts and this specific workflow is to send the audited agents an update requesting to sign off their results. Due the nature of data in the sheet, Agents don't have access, so once the QA…
-
Auto populate a contact cell but still with overwrite capabilities
Hello, I am trying to "suggest" a contact in a contact list column but can't find a way to automatically populate a cell while still having the ability to overwrite it later if that suggestion is not correct. So I've got a Program column, a Suggested column, and a Assignee column. Program is a dropdown and Suggested…
-
Trigger automation based on a count or multiples of a count
Hello. Im testing out triggering an automation based on a countif, but I cant figure out the logic to apply the automation as the countif increases. For instance. I want the automation to run each time we get 5 submittals via a form for the same category. Right now I'm using a metric sheet and a countif with a mod…
-
Formula for quarter based on finish date
I want to create a formula that will auto-populate the Quarter column with Q1, Q2, Q3, or Q4 based on the date entered in the "Finish Date" column. For instance, if the "Finish Date" is 4/15/2021, I want the Quarter to be "Q2".
-
Why is my automation to copy rows to other sheet missing data from certain columns?
I have an automation created that, when a row is added to sheet 1, the row is copied to sheet 2. Its working fine except it sometimes misses values from the "First Pay Date" column and the "IC" column and they dont get copied over. They will just be blank on sheet 2. I made sure that under column properties, they are set…
-
Embed form in an automated email
I would like to be able to embed a form in an automated email that is sent out to people once a week, so that I can request status reports. I would like to use this, instead of an update request, so that I can have a historical record of previous status and comments. Embedding the form will improve the user experience,…
-
Best practice of Automations maintenance
I've been using a sheet for customer support purposes, which is shared with multiple regions and groups. In the course of trial and error, we've created many workflows. As we didn't delete any, there are 13 Active and 14 Inactive workflows. Which is recommended to keep Inactive workflows or delete them? I'd like to know…
-
Automation to Resend Form
I have a sheet that requires a stakeholder to complete a form when their name is added to a Reviewer column and a checkbox for "Reviewer Assigned" is checked. I need a way to automate the resending of that form. Either a trigger via a new Resend check box to resend the form (but the automation would need to be viable to…
-
Automation messages sent from Organization but reply to sheet owner
Dear Smartsheet experts and friends I developed a long system with several automation interaction messages: alerts, updates, etc.... All our messages were set to go out using our Organization's name. However, some people decide to reply to those messages, instead of following the actions that we ask for. This creates an…