-
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};…
Formulas and Functions2
Sebastian Avila
-
I have been using automation workflow but there is no trigger for proofing. When will it be made available?
Using Smartsheet5
Lee Li Chuan
-
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?
Using Smartsheet12
Maria Watters
-
Hi-
While using the automated approval process, users are getting additional e-mail after they approve the request.
Is there a way to disable that? It just creates unnecessary e-mails and notifications serves to very little to no purpose.…
Using Smartsheet14
Enes Zorkul
-
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 f…
Using Smartsheet13
Improve Consulting
-
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 bo…
Using Smartsheet9
Oscar Dennison
-
I have an intermediate sheet with only one row that pulls the results of some calculations from my master data sheet in order create an archive entry.
This intermediate sheet has an automation set up to copy the row into my archive sheet a…
Using Smartsheet24
Werner Gerstacker
-
Several times a day I get requests to share a source sheet to a user who received an automated alert. Since the body text is small and the source sheet link if big and in a different color, i can understand why they are clicking on it. I h…
Using Smartsheet60
alcapps
-
I have a very simple workflow that is not sending email when rows are added. I have been testing with me doing the entry and I don't get emails. My notifications and Automation Permissions are correctly set.
Can anyone provide insight or …
Formulas and Functions65
Gary Norton
-
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 t…
Using Smartsheet20
Lauren Stedman
-
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
…
Formulas and Functions12
Gladys Liley
-
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,…
Formulas and Functions21
Matthew Smith
-
Client submits file through form.
I have an automation set up to respond to client when new file w/response is attached to row and "Status" and "Date" cells @row are populated. It works as intended but relies on peopl…
Using Smartsheet28
Gil Nash
-
Hello,
I want to set up a form for several kind of requests.
Once a request is created with the form, the idea of the automation I want to set up is to send an approval email to a first person, according to the type of request initially ch…
Using Smartsheet15
Ronan Lesage
-
I have a Slack notification being sent for a specific row in my SmartSheet.
It's a Template SmartSheet, so it gets "Saved as New" every time a new project is started.
I'm noticing that the Slack notification seems to get de-activ…
Premium Apps and Integrations11
Garo Stone-DerHagopian
-
I have a number of automated workflows set up to send alert emails that are no longer working. They were previously working fine for days (and I tested them repeatedly), but they have all of a sudden stopped. I haven't changed the automati…
Formulas and Functions92
Dani L
-
I have a sheet with 2 dates, original ship date and current ship date. I want to send an alert when the ship date changes, but not when the info is entered for the first time. Or, to not send an alert if the ship date is the same as the …
Using Smartsheet21
Tim Epp
-
I have a sheet and want to automate a request to assignees to provide an update at the same time each month.
How can I do this without a due date and a formula driven checkbox or flag that would trigger the request?
Formulas and Functions21
Phil Wightman
-
Has anyone had success in having SmartSheet include attachments on the emails that it sends from workflow you set up?
When I create a workflow in SmartSheet to send an alert to someone I want to have the email the user gets include an at…
Using Smartsheet577
Felicia Wilson
-
I have a sheet set up with parent rows for each month. I want to copy the child rows underneath the "July" parent row to another sheet using an automated workflow. What condition do I set if I want the rows under "July"…
Using Smartsheet72
mconne17101921
-
We are currently using a Form to submit requests for changes and would like to use logic to update the end date of a row after the form is submitted and based on the create date plus X number of days OR after a status is updated, if the en…
Formulas and Functions22
Kourtney Plotzker
-
I have a sheet that is being fed by a form. I am using a vlookup to add contact data from another sheet dependent on the email of the person who submitted the form.
I want those vlookups to be added automatically to each line as new for…
Using Smartsheet13
TJones Hoshizaki
-
Is there an easy way to validate that a request for approval submitted via a form is not approved by the person who created the request?
My sheet contains a Contact List column from which approvers are selected. I have tried to validate th…
Using Smartsheet48
Andy H
-
I am looking to implament project controls as below
One (1) workspace
All project sheets (no sub folders)
Project control Sheet
Reporting (at risk tasks, high priority tasks, hours per resource)
As projects start (need to be seen on the P…
Using Smartsheet13
Michael Van Itallie
-
Today the proposed changes to automated update requests / notification has now got the OWNER's name in the email.
This is causing us absolute chaos.
Update requests have been sent out and as they now have the owner’s name (in our case this…
Using Smartsheet1001
SueinSpain
-
Hi All -
I'm pretty well versed in SmartSeehts, but trying to help my company implement a Salesforce-like SmartSheets approach - to save cost. To be clear, I know there is a integration available with Salesforce, but we do not work with th…
Using Smartsheet22
Mike Rini
-
I have created an automation to request a form update. Not all the users are receiving the email. I can push the update manually to the user who then receives the request update. The Row Action Indicator says the email went out and sta…
Formulas and Functions49
Scott Verduin
-
I have users that misplaced or lost their update request email in Outlook and they want me to re-send them the link to update their specific projects. I know I can do it manually per each project but that will take some time to resend thos…
Using Smartsheet26
Mike Serago
-
Can anyone come up with a workaround for this situation:
I have a submittal log for a construction project. I attach and log submittals in Smartsheet as they come in from the general contractor, and Smartsheet alerts the applicable design…
Using Smartsheet82
coryg
-
I am trying to setup some sheet automation as follows:
Program Manager sheet: Tracking ID is auto-generated using auto-numbering
When a new tracking ID is generated would like to populate that new ID into another Master worksheet into next…
Formulas and Functions21
Jonathan Kearns
