Automations

Discussion List

  • Add a Formula to a Cell Using Automations
    In Formulas and Functions
    Is it possible to add a formula to a cell using an automation? I attempted to do this using the Change cell value action, but it only adds the formula as text. The sheet does not recognize it as a formula even though I did start it with …
    Answered - Pending Review
    21 3
    Answered - Pending Review 21 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • Pivot App Not Working Consistently
    In Apps, Integrations, and Add Ons
    Hello- I have a pivot workflow set up to run hourly however it looks like the pivot app is not running consistently. It did not run an hour ago but it ran twice two hours ago. It also didn't run 7 hours ago but ran twice 8 hours ago. I …
    Answered - Pending Review
    25 1
    Answered - Pending Review 25 views 1 comment Most recent by Genevieve P. Apps, Integrations, and Add Ons
  • Adding comments to approval process
    In Using Smartsheet
    Dear smartsheet-community, I am using the approval process for new incoming projects. Basically if a new project/line is added, an approval request is sent to 15 team leads and their choice (confirmed, declined, pending) is stored in 15 co…
    Accepted
    1425 20
    Accepted Answer 1.4K views 20 comments Most recent by Andrée Starå Using Smartsheet
  • Change Cell Value Automation for rows created in the past
    In Using Smartsheet
    Can you use the "change cell value" autopmation to update rows created in the past? Example. When you create a new status update row on a sheet can the automation change the status of an old status update to "not applicable…
    Answered - Pending Review
    16 2
    Answered - Pending Review 16 views 2 comments Most recent by mballen Using Smartsheet
  • Auto-populating a range of columns with a number based on dates in 2 other columns.
    In Formulas and Functions
    Hi, I am having difficulty figuring out how to auto-populate a range of columns based on dates from 2 other columns. For example.. A contract's start date is Jan 2022 and its end date it October 2022. The value of the contract is 10,000 US…
    Answered - Pending Review
    20 1
    Answered - Pending Review 20 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • Track inventory movement in multiple warehouse locations
    In Formulas and Functions
    Hi, We would like to track inventory movement between multiple warehouse locations, there is no need to track stock value/sales, just need to track inventory movement between locations and the inventory balance Warehouse: Warehouse A, War…
    Answered - Pending Review
    38 2
    Answered - Pending Review 38 views 2 comments Most recent by Ashley356 Formulas and Functions
  • Additional Options in Row Copy Automation
    In Using Smartsheet
    Please add an option to add row to top.  "The row will be placed at the bottom of the destination sheet and can then be manually dragged up or down to a different location."
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Jeff Reisman Using Smartsheet
  • Change Cell Value Automation - flag or symbols
    In Using Smartsheet
    I am wondering why you cannot set the value of a flag or symbol using the Cell Change Value Automation? I cannot see how to do it. I have a flag column that I want to let the users manually set to highlight what needs to be looked at and a…
    Answered - Pending Review
    261 8
    Answered - Pending Review 261 views 8 comments Most recent by Genevieve P. Using Smartsheet
  • I Can't Copy/Paste text out of an Automation. Anyone else?
    In Using Smartsheet
    I've discovered an infuriating bug (?) or complication with dealing with automations in smartsheets. I have a variety of automations in a key sheet that have email alerts for certain contacts. in these emails I have a link, specifically to…
    Accepted
    21 5
    Accepted Answer 21 views 5 comments Most recent by Jeff Reisman Using Smartsheet
  • Is there a way to easily/quickly hyperlink 100's of sheets.
    In Formulas and Functions
    I am running into an issue where it is desired that 100's of sheets in a workspace have an individual hyperlink on a separate sheet. The desire is that in card view, they can click on the hyperlink and go directly to that person's individu…
    Answered - Pending Review
    22 3
    Answered - Pending Review 22 views 3 comments Most recent by Andrée Starå Formulas and Functions