-
automation copying rows when conditions should send update request instead
Hello, I have a scheduling sheet where users update an existing row to reserve a meeting time. My automation workflow states to copy rows changed IF three fields are NOT blank Otherwise send an update request for missing field info. The issue: Rows are copying even when one or more of the three fields are blank AND even…
-
Automation Alerts work sporadically
Hi I'm working on automating alert notifications from Form submissions via email, Teams Channel and the Teams Bot and so far the Channel is the only one that seems to work consistently. In all scenarios in my testing, as you'll see in my screenshots of the workflows, my email is associated with the SME listed and I list…
-
Proofing Automation
How do I use the workflow automation for approval with Proofs? For example, I need to send a PDF proof through a workflow to be approved, but I am unable to do this through automatic workflows (cannot add a Proof) nor the Proofing feature, which is not automated. Also wondering if I can use dynamic cell data in Proofing…
-
Automated Workflow fields - can they be duplicated?
Hello knowledgeable ones, I have multiple workflows for approval/assigning within one sheet. In each of these workflows we want to send certain fields via the email. Do I need to select each of these fields for each (30!!) of the individual workflows? I cannot see how to copy and paste the relevant fields. I am assigning…
-
Showing only those selected fields with a value in the Approval automated workflow?
Hello. Another Automated workflow question. Is it possible, within the 'customised message' where we select 'Specific fields', that there is a setting that will only show those fields if they have a value? So, for example, someone completes a form, and certain sections may not be relevant, but the automation is set up as a…
-
Contact us integration ?
I'm running a recruiting campaign and I need to log all of the leads that are going to come in from separate landing pages. Is it possible to have those contacts be uploaded to a spread sheet the moment a person submits an application?
-
Automated Workflows - Person who email comes "From"
Hi... is there a way to edit WHO the automated workflow email comes "from"? I know it defaults to whoever set it up. But if that person moves to a new role - etc - I'm assuming there has to be a way to edit that information? A workaround that I considered - but didn't test yet - was perhaps having the "new" person…
-
Is there a formula for referencing a different cell daily?
I've automated emails to send out schedules to our field employees but their sites can change daily and I was wondering if there's a way to reference a different cell everyday so I don't have to manually change the site cell in the automated workflow.
-
Sending a form for authorization/signature
Hello, I am very new to Smartsheet so please bear with me. Every year we have a group of applications for a program. In the past they filled out a pdf form, but I'd like to start having them fill it out online. The problem is that while the applicant fills out the information and attaches supplemental files, a final step…
-
Is it possible to to be notifed after an automated email is sent?
I've set up daily emails for our employee schedules but I'd like to receive notification after the automated emails are sent.