-
Individual Update Request Emails
Hi there! I am using Smartsheet in an educational setting where each row includes information for an individual student, and there are multiple users that update that data. Currently, I am using an automation so that when one user checks a box in a row, Smartsheet sends an update request email to another user listed in a…
-
Automated Move Row upon Trigger isn't working
I have the following: Sheet x: Various imports from Excel - rows are copied, by right clicking Copy Rows to Sheet A. Sheet A: Full list Sheet B: has formulas that update from Sheet A. Sheet C: Closed items Issue is that when Sheet B has a Status cell that is updated from Sheet A (via formula), a trigger should be thrown…
-
Ability to limit which columns are copied using Copy Row
This is more of a question for clarification. I'm just now getting around to using the Copy Row feature and want to copy only a few of the many columns from one sheet to another. Is this possible? During my research, it doesn't seem like it is, but I haven't found anything definitive. Thanks for the help.
-
Sheet summary - column formula
Hello, I am creating a smartsheet that aggregates the clubs that certain employees are in. That main component is done, and I am now using the sheet summary function now (mostly using COUNTIF) to link to a dashboard. However the number of entries on the sheet will change with new employees, which makes the sheet summary…
-
Vlookup functions not working on a Master Spreadsheet
My colleague and I, who do extensive work on a master spreadsheet that pulls data from many different sheets, are having a lot of trouble with the vlookup function on this particular sheet. We use the vlookup function in multiple different columns on the spreadsheet in question, pulling data from a different source sheet…
-
Automations not working
Hi I am trying to get an automatic alert to be sent out to certain email addresses once 3 tasks are completed. I have included these tasks as 'conditions'. However, this does not seem to be working. I only receive the alert if one task is selected. Is there a way around this?
-
Is it possible to automate export of specific cells on a triggered event?
When our "Completed" column is checkmarked, we wish to export that row and its children rows to an external file such as .csv, Excel, or Google Sheets. If possible, we would also like to export the attachments for those rows as well as reformat this data. Is this kind of automation possible? Built-in, 3rd party…
-
Is there an API for automating parent/child indentation from a form?
Hi! I am trying to create a smartsheet that automatically indents child rows from a form submission. Right now, there is a main "parent" form, then a linked "child" form that creates a new row under the first, but they all come in at the same level of hierarchy. I'm looking to automate the indentation because there are…
-
Is there an automated workflow that populates data in cells based on triggers and conditions?
Hi Smartsheet SMEs! Please share any success you've experienced in creating a workflow to automatically populate cells using select triggers and conditions without using a formula. Thanks in advance for your feedback/suggestions. Edwina -
-
Checkboxes to Generate List
Good evening! I need a little help to see if what I want to do is even possible. I am wanting to create a list of people based off of a response to a checkbox. For example, if someone completed a form with their name, address, and other fields to include checkboxes, and checked a box titled 6/7, I would want that person's…
