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.
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)))
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.
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…
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)…
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…
Hello, If I start an automation in the past, will it trigger on a date in the future? I want alerts to go start this coming Friday 2/25, and every two weeks after that. I set my automation up like this: Will this work?
Hi, I am trying to prepare reports that show certain information (eg, here are all the things that have happened in the last week/month/are coming up etc). If I do it as an automation in smartsheet, I cant seem to link certain columns without a linking the whole sheet (which contains sensitive information). In reports, the…
We have a column with expiration date that is put in manually by an employee with the rest of the data when received. Currently we have conditional formatting to highlight the products expiring within 30 days via the row turning yellow. We need a cell that will automatically count and display a value for all yellow…