-
How do I get my workflow to work?
Hi could anyone help me with this work flow? Firstly I wanted once a row was complete, it would delete, however i read through some of the comments and showed that this was not possible. Instead I wanted once the row is complete, to move into a separate spreadsheet, however the work flow isn't working. Could anyone help?
-
Allow data entry only if another column is not empty
Hi everyone, To help you understand, our business is about rentals. In our sheet, we have columns for: Date the contract was issued Date "from" (when the rental starts) Date "to" (when it ends) I am trying to find a way to allow Data entry in columns 2 & 3 only if there is a date in column 1. If column 1 is empty, employee…
-
Is it possible to format the body text of an email reply under Alert someone? Will the body text und
Is it possible to format the body text of an email reply under Alert someone? Will the body text under Customize Message accept HTML or another markup language? I would like to include a couple of hyperlinks and apply background color highlight to a few words.
-
Automated Workflow in archiving the data in the sheet
We are using the Smartsheet form to collect the real-time customer experience survey data. One of the challenges is, after a few months, the number of rows in the sheet will approach the 20,000 rows limit. Therefore, we need to manually go in and move some of the older data to a new sheet to allow the space for additional…
-
Is it possible to NOT display the Row Number in an Update Request email?
We have a sheet that collects basic award nomination information using a Form submitted by the nominator (indiv A). We then need the nominee (indiv B) to update their mailing address with us. We are using an Update Request automation to capture the address information on the same row in the sheet as the rest of the…
-
How do I send row data to an email contact in the same row every 30 days?
I am wondering if anyone can help point me in the right direction in setting up this smartsheet. We are trying to automate an email notification for over 100 employees for when they receive a time accrued balance at the end of the month. I was thinking each employee will have their own row with the time accrued balance,…
-
Workflow and cell linking.
I have two sheets that have linked cells. I want to use the workflow to make the tasks from the second sheet disappear if the Status column says complete. Is this possible? I know how to set up a workflow to move cells to a new sheets but it does not seem to be working. Is this because I have the cells linked to another…
-
Monthly Reminder Automation
Is there a way to send a report monthly of changes that have been made to a sheet? The max length in the workflow is Weekly. Does anyone have a work-around for this? Thanks!
-
Is there a way to track where an automation is coming from?
I set up some templates with automations for my colleagues to use. The intent is that they would adjust the automation settings to send the alerts to themselves. However, I continue to get "false" automation emails that are NOT tied to any of my sheets (i made sure all of my automations are correctly set up and the ID…
-
Automation Question
Hi All, I have created a workflow to copy the incoming data on to different sheets as per the criteria. Now my questions are: 1) Is there a way to only copy certain columns when automating the work sequence? 2) When the data is copied to another sheet, can it be copied on the top rather than bottom? Thanks in advance. :)