-
Return update request URL via Smartsheet API
Update requests can only be accessed via recipients' email. In this community discussion, several use-cases are described in which it would be useful for admins or developers to be able to access the URLs associated with update requests. In my organization, it would be extremely valuable to be able to access update request…
-
Alert when all proofing feedback has been received
Would be great if an email alert can send out to the person who invited users to review a proof for when "all" feedback has been received for when you have multiple people reviewing the same proof. This way as you receive feedback over email for when a user clicks to "Approve" or "Requires Changes", you don't have to keep…
-
Automation emails not sending consistently to some contacts
I'm running into a strange issue with automations and email delivery, and I'm hoping someone can clarify how to fix this. Setup: I have a Smartsheet form with: A required “Your Email” field (Contact column) Several hidden Contact List fields populated automatically Automations use “Send to contacts in a cell” Submitted…
-
Roadmapping with data living in SmartSheet
Hi all - Currently some functional areas of my organization are doing roadmaps similar to the image attached for their leadership. There's a desire to have the data for these roadmaps live in SmartSheet and push towards report automation. They really like the condensed view with multiple items in a lane (vs rows on rows on…
-
Trying to Eliminate Unnecessary Automated Announcements
I have an active automated notification in a sheet of project tasks that lets the "assigned to" know when anything has changed in their row. However, they don't need to know about changes they made themselves so I am trying to eliminate those. I set up a column called "MATCH" and added a formula to check for a match…
-
📣 Smartsheet is Hitting the Road: Join Us In Person!
We’re bringing the Smartsheet community together across several cities, and we’d love to see you there! These interactive User Group sessions are your chance to level up your processes and connect with peers. 📍 Sydney, AUS When: Thurs, Mar. 12 | 9:00 AM – 11:00 AM AEDT 📍 Stockholm, SE When: Thurs, Mar. 12 | 1:00 PM – 6:00…
-
Welcome to the Healthcare & Life Sciences Community!
This is a space for Smartsheet users that work in the Healthcare and Life Sciences industry to connect, share ideas, challenges, best practices and how you are using Smartsheet to transform Healthcare & Life Sciences. Our Smartsheet team will be sharing helpful resources, upcoming industry events, discussion questions, and…
-
Creating a formatted/merged email from a grid
I have a complicated workflow that I'd like to significantly reduce, in terms of time spent. Working from a standard grid, I need to format the email, pulling some summary information for a project and then adding specifics for each individual tied to each project. A few points: the summary information is currently in a…
-
Complex Automation
In a sheet, in the primary column (Task Name), I have multiple parent rows with all of the same child rows beneath each parent row. A simplified example is each Parent Row is a new lot number, with two associated child rows called "Date of Shipment" and Date COA". There is also a drop down Status column. I want to create…
-
Conditional Formatting in Rows Resulting from Formulas
Hello, This might be somewhat of a long/confusing one. I am trying to figure out how to better automate categorization for blood pressure categories when being placed into a sheet. For example, in the image below the column "BP" is where the initial number is input. I then put a LEFT formula in the column "Sys formula" to…