-
How can I log a timestamp of a cell change?
I want to add an automation rule to write a timestamp of when a cell value changes, I know I can use the "record a date" automation to get the date but is there any way I can get the exact timestamp similar to the "created at" field in form responses? I am also looking into a way to implement it using the API and there…
-
Automatic Mirror for Sheets Associated with Forms
Presently, the Sheet that is connected to your form does not automatically arrange the columns in order of the responses on your form. It would be helpful for the Sheet column order to mirror the forms responses as the standard and then allow you to manually arrange if you wish to have a different order. The manual…
-
Automate Group membership management
Idea is to automate group management based on some users' information like: email domain Licensed/unlicensed Active/Inactive User description or attribute that can be used to enter text to be used as filter And also schedule report to send group membership to group owner.
-
Sheet automations and cell updates
We have a recruiting team for our clients. When the client requests us to fill a job role, they can specify one or more jobs in that role. When the recruiter fills one job, I copy the row to another sheet for billing, then I want to reset five key fields and decrement the number of jobs to fill. Does anyone have any…
-
How to set up automatic notification when entire column meets the criteria?
We are trying to build a monthly checklist with various tasks our team members need to complete. Some of these tasks need to be completed before another task on the checklist can be completed. Specifically, we need our users to upload their payroll cash batches into our accounting system before another user can populate…
-
LookUp Results then Automate Resonse
Haven't had to much experience with smartsheet, other than setting up some connections and sheets. Trying to accomplish this automation though; I have a connection adding rows/updating rows when source changes. I want to make a form or dynamic view (if possible) that allows a viewer/user to enter a PurchaseOrderNo…
-
Unable to Run Copy/Move Automation
I have several sheets in which I utilize automations to move/copy rows from one sheet to another as the rows move through our workflows. So of course, each subsequent sheet has duplicate column names. I had to make a change that ended up completely breaking all of these move/copy automations. The change that broke…
-
Rolling updates - can I automate data selection for dashboard?
I have a set of dashboards used to show the same data every reporting period. Reporting periods are 100 days long. They are identified as Start Month - End Month (x00 days). Is there a way I can automate data selection for my dashboards so that it picks the current reporting period ? Data feeding into the dashboard comes…
-
Automation Copy Rows - Select a Destination Sheet
Hello, I'm running into an issue I've found through past forums. I'm attempting to copy rows from one sheet to another. I am the owner on both sheets. What could be the cause of this? Both sheets are in the same folder… Thank you
-
How to Import MS Project File into Smartsheets, but with the Time stamps from MS Project?
When I try to import MS Project File into Smartsheets, it automatically treats the import as a project and hence the result only appears with the Start Date and Finish Date, and I lose the time stamps in from my MS Project File. I also tried taking an export of excel file first from mpp., but as I export to Excel, I lost…