-
Separate form submissions from reference data
I've imported a CSV File into Smartsheet that serves as my database repository for Form Fields. My Form is created on this sheet in order to reference data values within the grid for multi-select form responses, which are limited to the values provided. I would like for form submissions to land on a separate sheet as my…
-
Due date automation - how can I do this?
I'm working on a project to automate the flow of processing between multiple staff, each task will have 1-3 days to process [due date] depending on the task. Is there a way to assign the due date through the automation process? I have it assigning when the previous person has completed their task, but I'm not seeing how to…
-
Google Sheets integration - automatically updating cells in GSheet when SS is updated?
Hello! I'm looking for a way to automatically update cells in Google sheets, when a cell in Smartsheet is updated. For example, if a Date changes in Smartsheet, Cell C4 in google sheets would update to the new date. Is this doable? Thank you!
-
Need a formula to have all work-flowed moved cells to go to the top of the sheet
Every time I put an automation to move cells to another sheet, they end up at the bottom of the new sheet. Is there a formula I can use so that they can start coming in at the top? Thank you!
-
Automation Notification email issue
Hello. Does anyone knows if there is a way to modify the Automation notifications to come out from a vanity email like " NO_REPLY@Company Name.com instead of the name of the person that setup the automation? Im getting seveal people reaching out to me thinking that I manually sent them the email asking for updates.
-
If statement to return age of modified row based on certain statuses
What am I doing wrong? =IF([status]@row = “shipped complete to customer”, (TODAY() - [Modified]@row), IF(OR([status]@row = “shipped complete to iti warehouse”, (TODAY() - [Modified]@row)))
-
Why is one sheet workflow bringing the cells to the top and 1 sheet is bringing the cells bottom
I have two sheets that workflow to a separate sheet. One sheet will put the cells at the top and one will be brought to the bottom. How can the cells be workflowed to the top of the separate sheet.
-
Form entry/Copy row automation/Row location
Hello all! I am really hoping this is something easy I am just overlooking. The sheet above has a form. When the form is completed the row of information does not populate in the first available row, but a random row typically 25+. The sheet above had the first row populate at 49 and the automation from this sheet to…
-
Nightly Automation with Today Formula
I seem to have a 'ghost' in my sheet where only half of my automated workflow seems to work on any given day. My sheet (called a playbook) has half of the rows with =Today() date formula, and the other half with a hard-coded date; each night at 11:00pm PST my worflow copies the Today rows to a 2nd sheet (called a tracker)…
-
Is there a way to use automation across grids?
We're using Smartsheet to track project requests. I'm working to build "personas" to show the type of projects coming in based on the requestors job function. Is there a way I could use automation to add data from another sheet so that once we receive a request the automation can reference the requestor's job function and…
