Automations
Discussion List
-
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 19 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 35 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 237 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 19 views 3 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Workflow condition starts with < NIn Formulas and FunctionsWe have a use case where an assignee is variable based on an ID 'number.' The ID Number starts with a letter code, and the assignee is IF ID starts with A-M THEN AssigngedTo = [email protected] ELSE AssigngedTo = [email protected]…Answered - Pending Review 26 views 3 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Request Approval Automation working in one direction onlyIn Using SmartsheetHi Guys I have an automation running for approvals. Ill add an image for reference. What I'm trying to achieve: We want PERSON A to be able to make a request to PERSON B. B must then approve or decline. Upon B's approval a new Approval Au…
-
Looking for solution to add Outlook calendar invite information to SmartsheetIn Using SmartsheetWe want to create a Smartsheet that is automatically populated with Subject, Location, Date, Time, Duration when we invite an alias to a meeting. Is anyone aware of a way to do this? We would do this for all of our project/program meetings…
