-
Smartsheet Automation Problem
Here is a very simple automation which says that if a row is added or changed, and the value of Status is blank or 'On Hold', then change it to 'Backlog'. Now i add two rows, first has status blank, and second has status 'On Hold'. The automation changes the value of second row and not the first. Anyone has an idea why? Is…
-
Batch Sheet Creation from Template
Problem: Current Limitations Manual Repetition: Provisioning a large project (e.g., 50+ distinct team sheets) currently requires manually executing the "Use Template" or "Duplicate Sheet" workflow 50 separate times. Time-Consuming Setup: There is no native bulk-action to instantiate multiple files at once, creating a…
-
Automation Message to specific contact with only their relavant entries
I have a grid with date from multiple users. I want to be able to send out a message each month to the user showing only the entries they provided. For example, Leo would get one message showing his client, date, program name and #_participants. While Sandy would get one message with the two different clients and the…
-
Override formulas and hard code cell values once a row has been locked.
I'd love to have a condition where cells or columns are hardcoded or locked once critiera is met. Currently the lock feature does not override any formulas, so values can change within a locked row should a formula trigger a change. This defeats the purpose of a locked row in my opinion. Since we have many helper columns…
-
Workflow condition
Hi All, We have a workflow that requires approval from HOD followed by approval from CRO. In the normal situation the HOD is different from the CRO and each individual receives the approval notification email. However, in some cases the HOD is the same as the CRO. So he is getting 2 email notifications for approval. We…
-
Hide the title bar from emails
For the automated emails, I need this section hidden or smaller. Most of the time, I have to scroll down to even look at one sentence of actual data.
-
Automatic email replies going to personal inbox
Good morning, Smartsheet community! I work at a community college and recently began utilizing the Smartsheet automations to send email reminders to our specialty program students. In the email body, we provide an email they should contact with any questions they have. However, I have had some students reply to the…
-
What would be causing only some individual to not receive automation emails?
I have a simple automation set up to email a reminder to people listed in a contact list cell. When the automation runs, I get the email, others get the email, but one (possibly more) individual does not. This individual gets emails from other automations running in the company. The automation does show up in their…
-
how do I record the date that a particular drop down option from another cell was last selected
how do I record the date that a particular drop down option from another cell was last selected. In this instance i want smart sheets to record the date that "4. waiting for customer response" was changed. I want to apply this automation to the whole sheet.
-
Respond to a Smartsheet Automation e-mail (via e-mail)
I have an automation to alert someone if an item is assigned to them on a sheet. The email is received with the detail but the individual then has to go into Smartsheet to respond. If a user is tagged in a comment, that is emailed to them and they can reply to the email, which will land back in the Smartsheet conversation…