We have a sheet used to track jobs status, at any given time we are entering jobs in batches of 20-30 copy/pasting from an excel spreadsheet. Would a template work better for batch submission? Thanks!
Can I make an automation where it copies rows from one sheet to go under a certain parent row of another sheet instead of just at the bottom
I would like to build a link to a Smartsheet form from another sheet's workflow, including default values as described here: https://help.smartsheet.com/articles/2478871-url-query-string-form-default-values Those default values should be set from a cell using {{ }} as described here:…
How do you search conversations in a sheet to find a previous comment? Thanks!
Hello, I'm trying to divide cells in one column by cells in another column. After reviewing several similar questions I created this formula: =SUM([SOR - # of Users Activated]72:[SOR - # of Users Activated]75 / SUM[SOR - # of Users Ordered]72:[SOR - # of Users Ordered]75) This of course is not working, Could you advise if…
Hi there, I've created a form that splits into two logics for donation only and event/activation. Some of the logic questions over lap and the required questions vary for each logic. Can i make questions required for one logic but not the other? Thanks! S
The recent announcement that Automations will include sheet owners and users names is a huge disappointment! We needed Alerts to be anonymous! I have requested that for years now. This is the exact opposite of what was requested and what I have seen in the community discussed. Our business utilizes automation to send out…
Does Smartsheet have the capability to incorporate macros into a sheet. Like in Excel, if I want to create a new report every month I click a button, and the info on that sheet moves over to last months cells and the current months cells are blank for me to fill in? Is this possible in Smartsheet? If so, how?
When sending an update request for say a ranking from 1-10. The column may have a restriction to only allow valid values but the Update Request Form will allow anything, even text. This breaks the first rule of good data GIGO and requires us to spend time not only cleaning bad data, but chasing back after the person who…
Is there a way to have a setting on a sheet that would allow it to override the restrictions put in place for automated alerts going to email addresses that are not in our Approved Domain Sharing List? Here is our scenario. We locked down our Smartsheet sharing so that someone cannot share a sheet to someone that we do not…
How would one go about getting access to a sheet/form if the person that created it is no longer employed?
Hi there, I am hoping to find a way for our staff who submit information through form to receive an email confirmation without having to get a copy of the information they fill in the form. At the moment the only email option is to have them get a copy of their response to the form, but I don't want them to have a copy of…
How can I customise an update request in a workflow, so that the updater has fields that are required to be updated before submitted the update?
Help shape the future of Smartsheet. Share your ideas and feature requests.