-
Checkbox find duplicate in a column, do not check either box if either has a value in 2nd column
I am using a checkbox to find duplicate entries in the column name Email. I can up with this that worked, =IF(COUNTIF(Email:Email, Email@row) > 1, 1). Next, I am looking for both duplicates to not have a value in the Using Generic Account field and then check both boxes. Do not check either box if one of the two…
-
Input/auto fill data from different rows
Hello, Please find the example photo I would like if there is a formula that can auto fill and input data in blank columns/same row once i type the phone number (in column phone) by calling or looking up for the data from other rows in same sheet (or from other data pase sheet) taht engaged with same phone number. For…
-
Why is my automation not triggering?
I have two columns I would like to run in an automation, one contains a check box and the other contains a drop-down menu of text values. I am trying to run an automation in which when I check a checkbox in one cell, it updates the "Status" cell in the same row to 'Complete'. The automation either doesn't trigger or takes…
-
Datamesh very slow to update
Hi, we have datamesh set to immediate but it still takes up to a minute for the data to be pulled into the sheet. Is this the normal amount of time it's supposed to take? Or have I missed a trick?
-
Allowing Multiple Smartsheets to be published to One Google Calendar
I would love to be able to publish several of my smartsheets to one google calendar so everything is in one place. Please let me know when this feature maybe added! Thanks
-
Automated Email 2 days after a date if no attachment
Hi There, I have a fair bit of automation setup in my workspace for all the relevant rollout / install sheets to do multiple things including: Send reminders 1 and 3 days prior to ensure the store/retailer is aware and the space is clear Reminder on day of install at 5pm to ensure an attachment of the evidence of install…
-
Need to identify who responded in the survey
I have two sheets. Sheet A is the master list of the names while Sheet B is the list of the respondents of the survey form both containing the unique identifier code. I need to identify who has and has not yet responded to the Smartsheet form. Questions: Is there a way to automatically mark Sheet A when a person submits…
-
Automation Workflows - Alert Someone - Ability to see full distribution list
The Automation Workflow to alert someone when certain actions occur is a wonderful feature. It would be a great enhancement to have the email show everyone who receives the notification. A lot of times, the workflows are setup to alert multiple people, but the email comes through as showing only the recipient. Sometimes…
-
Why is this happening all of sudden?
Hi all, I have had an automation set up (and working fine for quite some time) that copies a row to another sheet and then moves that row to a different sheet (Archive) when "send to Archive" is checked. As stated, this workflow has been performing perfectly for several months. Nothing in the source or destination sheets…
-
Changing File Directory for downloaded attachments
Hi all, For context, I use a Form to manage incoming service requests and generate PDF Work Order attachments. I would like to change the file directory for downloaded attachments to a shared folder rather than 'Downloads' so my supplier has visibility of the work orders when they are assigned. I can't seem to find an…
