-
API Questions
Hello, I'm new to Smartsheet but an old hand at data analytics. We have a group using Smartsheet to manage their project data, and they have asked to have their data merged with other in-house databases to provide consistent reporting. We are looking at using the API to set up an automated process to read their sheets and…
-
Add a Formula to a Cell Using Automations
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 an "=". I'm trying to populate the value of a cell with data from a cell in the same…
-
Pivot App Not Working Consistently
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 have this feeding a report that is automatically distributed at 5pm everyday so it went…
-
Change Cell Value Automation for rows created in the past
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" or does the automation only interact with newly created rows?
-
Auto-populating a range of columns with a number based on dates in 2 other columns.
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 USD. I would like to populate columns Jan 2022 through October 2022 with 1,000 USD in…
-
Additional Options in Row Copy Automation
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."
-
I Can't Copy/Paste text out of an Automation. Anyone else?
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 a dynamic view but that is irrelevant, that I am trying to copy out of the body of…
-
Is there a way to easily/quickly hyperlink 100's of sheets.
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 individual sheet. I understand that the desired effect can be obtained by running a report…
-
Request Approval Automation working in one direction only
Hi 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 Automation is triggered back to A to accept what was issued. We have about 50+ PERSON…
-
How to set the automation to trigger when status column in all rows are "Closed"
I am using Smartsheet for inventory stock count, and want to trigger an approval when staus column in all rows are "Closed", and then the approver could approve the whole sheet in just one step. Is there a way to do this?
