-
How to reference Sheet Summary cell in the text of an automation?
I've been usign columns references in the text of my automations messages a while now. It looks like that. The text is in french but you can see the symbols used. Bonjour {{Fournisseur}} Voici la confirmation de commande pour le projet {{Projet}}. La date de début est le {{Date de début}} La date de fin est le {{Date de…
-
Question about collecting feedback via form or request update
Hi I have a bit of an issue that I am struggling to solve myself. I have a worksheet with that gets updates via data shuttle with a list of employees nominated for a performance award. I want to collect feedback from their respective unit managers on specific criteria. The feedback is a numeric rating that answers specific…
-
Automation isn't updating my email subject line as I had entered - what am I doing wrong?
Hello, I am having issues with automations not updating to show the custom subject line I entered for emails. I am not sure what I am doing incorrectly. Can someone please review the screenshots below and advise me? Thank you! Here is what I expected to see in my email: Here is what I got:
-
Approval flow status - need help
Hello, I am in the process of creating a sheet (two separate forms depending on requesting line of business). My team handles one operation while my peer handles another. I have the automation when forms for specific lines of business it will send our respective teams an update will be sent via email. I also have a hidden…
-
How to Completely Remove PII in order to comply with GDPR?
Hi, I have a use case that is leading to some larger questions about how Smartsheet manages PII. In this application, we offer users a form to enter their information (name, address, email etc.) into a secure sheet for our limited use. This is all relatively easy, clean (and secure). However, it gets tricky to comply with…
-
Merge Multiple PDF Attachments
Hello, Is it possible to set up an automation that will combine multiple PDF attachments into a single PDF? For context, I have a sheet where we collect requests and the supporting documents for each request are attached at the row level. When I send these for final approval, I want to be able to combine all of the…
-
Can you create an automation to automatically enter links in one sheet to a template?
Currently, we have a sheet created from a form that we add hyperlinks to from a template we create to reflect the project health, status, and then manually hyperlink the template to this sheet. We would love to run an automation that will automatically create a template and automatically enter these hyperlinks to the sheet…
-
Transform rows in columns
It would be very useful to have a function or automation that allows to copy (based on a selection criterion), the values in the rows of a column and transpose them on a single row of another sheet, on a corresponding number of columns. Example: In a source sheet I have a column with an identifier code; I want to copy all…
-
Creating an approval form from a submitted user request form
Hi, I have successfully created a form that allows a new user to provide their information, their requested access level, and their supervisor's name. When the new user submits the form, I want another form to be triggered and sent to the supervisor for their approval for the new user. Thus, the form would include the new…
-
Automation Failing
I have a move rows automation that will not run, even if I push it at the single line level. I have a sort of multi level baby database I work with it's built of 5 total sheets with the fifth sheet being a rotating retirement sheet. sheet 1 is where new data is pasted in, once new data is added it's moved to sheet 2 sheet…
