-
Approval Request with Multiple Conditions only Sending First Request
I need an approval request to run to any impacted team leads when a new estimate is uploaded. For example, if a new estimate is uploaded and the departments included are Search, Social and SEO, I need an approval from the lead of each of those departments. I have an automation set up for approvals that is triggered when a…
-
Is there a way to send a Notification for a specific Row only?
I have a situation where a single line item is critical, but it has multiple dependency tasks that can impact things without the general user knowing. I'd like to be notified when the dates on a particular task are changed, whether inadvertently or on purpose (based on changes to the dependent tasks).
-
COMPARE COLUMNS
Hi have two columns with ID´s and i want to compare them see, if an Id number has a match or a mismatch in the other column. What kind of formula de you recomend to do this? I used Vlookup: =VLOOKUP([NÚMERO DE SINIESTRO]1; {SINIESTROS CF}; 1; false) and Match; =MATCH([NÚMERO DE SINIESTRO]1; {SINIESTROS CF}; 1) But i only…
-
Sending report link as automated alert
Hi. I'm sending a link to my report in an automated workflow as an "Alert Someone". The recipient email contains a link to the report and a snapshot of the report, but it is limited to 100 rows. A message appears at the bottom that says 18 more rows not shown. Is there anyway to include all rows in the report in the email,…
-
Automation workflow & Proofing trigger
I have been using automation workflow but there is no trigger for proofing. When will it be made available?
-
Stopping Automatic Update Requests
Hello, I have many automatic update requests throughout a smartsheet; however, is there a way to create an automation that cancels the update requests without me having to go into each row and manually cancel them?
-
change reply email on automation
Hi, I setup automation on my clients' smartsheets systems. Now I have many emails coming from their subcontractors who reply to me when they receive an automatic update request. How can I stop it happening for existing setups prevent it for future clients thanks, Lauren
-
Forms Automation
I have created a form and have set up an automation that sends the form link to a customer. When the customer opens the link from email the form is different than the form I created. It includes the customer email address as a drop down box and the customer can see other customer email addresses. Also includes a upload box…
-
Trigger Move Automation
I have a automation that is not being triggered, here's the setup: formula to number the time a value appears (1, 2, 3, 4, 5, etc) in the Duplicate column Move Row automation triggered when there are any add/changes and Condition a. Duplicate is one of 2, 3, 4, 5 b. Duplicate is not 1 c. Duplicate is equal to or greater…
-
How to auto-populate hidden values for forms?
Hello, my name is Matthew, and I am working on a project that gathers data from clients. The goal is to receive documents from them and have them uploaded to SmartSheet. I would like to be able to send them a form based off a contact cell, but I am having trouble with this. The other issue is, unless they type what we have…