Automations
Discussion List
-
Add a Formula to a Cell Using AutomationsIn Formulas and FunctionsIs 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 views 3 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Pivot App Not Working ConsistentlyIn Apps, Integrations, and Add OnsHello- 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 views 1 comment 0 points Most recent by Genevieve P. Apps, Integrations, and Add Ons
-
Adding comments to approval processIn Using SmartsheetDear 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…
-
Change Cell Value Automation for rows created in the pastIn Using SmartsheetCan 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…
-
Auto-populating a range of columns with a number based on dates in 2 other columns.In Formulas and FunctionsHi, 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 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
Track inventory movement in multiple warehouse locationsIn Formulas and FunctionsHi, 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 views 2 comments 0 points Most recent by Ashley356 Formulas and Functions
-
Additional Options in Row Copy AutomationIn Using SmartsheetPlease 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."
-
Change Cell Value Automation - flag or symbolsIn Using SmartsheetI 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 views 8 comments 0 points Most recent by Genevieve P. Using Smartsheet
-
I Can't Copy/Paste text out of an Automation. Anyone else?In Using SmartsheetI'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…
-
Is there a way to easily/quickly hyperlink 100's of sheets.In Formulas and FunctionsI 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 views 3 comments 0 points Most recent by Andrée Starå Formulas and Functions
