-
Collecting Duration a Row is on a Status
Hello, I am working on a sheet where we have several statuses that can go in just about any order. We have a suggested flow, but it's more to help the user read through and make sure they didn't miss anything. I've listed the statuses below for reference. For example, the user could go from 1 to 2 to 3 to 4c to 14 to 16.…
-
I Need to set up email automation,
I need to setup email notification for 'Assigned To' contact list with respect to Caldue date coloumn. Every time I try the emails gets sent in to all the contacts in assigned to. Help me out ASAP
-
Issues with "Record a Date" Automation
Hi all, Any idea why this automation isn't recording a date? We have a formula that's designed to return a value of "Reorder" whenever the inventory for that products dips below a certain threshold. The formula is working, but it's not being recognized as a trigger with the attached automation. Any advice would be much…
-
I need to run an external report from our ATS software & merge it to smartsheets with automations
I will be pulling a weekly report from our ATS system to create a "master data sheet" of all of our requisitions. I want to put this into a smartsheet sheet & set up automations from this to allow me to remind our recruiters to complete action items & track the health of the requistions. How can I do this seamlessly &…
-
Is there a way to grab attachments from a new line in smartsheet and merge it with the print file
Hi, I have been trying to work on a system that will automatically take attachments from a new line in smartsheet and be able to merge it into 1 pdf file with the print pdf of the smartsheet line. I have tried using power automate to computerize this process, but there is no option for me to grab attachments. I have…
-
Automating Monthly Generation of Multiple Reports
Hello Smartsheeters! I have 14 reports that pull data from a master sheet that we need to report to an Important Entity each month. I'm hoping I can get out of the routine I have now, which is to save the batch of the prior month's reports as new and manually update the date parameters and the title for all 14 reports. For…
-
Automating Task Assignments based on Custom Fields - Emmanuel Katto
Hello All, I am Emmanuel Katto from Uganda. I'm trying to automate task assignments in Smartsheet based on custom fields, but I'm running into some issues. I have a custom field called 'Project Type' with values 'Marketing', 'Sales', and 'Development'. I want to assign tasks to specific users based on the value of this…
-
How to Make Automations Based on Attachments Work? Subsequent Actions Trigger Out of Order.
I have an update request (#1) that is sent to employee "A," who has to download, update, upload an attachment, and hit submit. I have an automation in which a date is recorded in cell #1 when an attachment is added or changed. This part works fine. When cell #1 changes, an update request is sent to supervisor (#1) who has…
-
Automation: To use multiple condition paths to automate multiple Columns
1. I have created an automation workflow with multiple condition paths. 2. Each condition path is to identify the certain key words in the respective contact a columns mentioned in it. 3. As an action replace the contact containing the key words by 'Action: assign a Contact'
-
Use generic name for Smartsheet automated notifications that can be easily updated
When I have changes in a number of Smartsheets due to personnel changes (terminations, new hires, promotions) I have to go through a large number of sheets to change the destination address for the notifications. For example, Kathy might be my accounts receivable person. When she changes roles, I need to change the…
