-
Delete a Sent Update Request
Since Smartsheet doesn't have the option to resend update requests that haven't been completed, I wrote a script to pull all sent update requests, filter on pending requests, generate+send new requests, and delete the original request. The problem I'm having is that the delete update request call fails every time. It fails…
-
Backup tool for one user only?
I am using the backup tool provided through the below link with SmartSheet. The issue we are running into is that we do not need it to backup every single user (this is time consuming and bloats to over 3 gigs of data currently). We are looking to keep this more targeted if at all possible. Has anyone had any luck altering…
-
Having multiple paragraphs in one cell for Approval Request
I'm trying to use Approval Requests for something and some of the columns are analysis's and are written in paragraph form. This is a formal process and I want it to look as professional as possible. Even though in smartsheet I can use Ctrl+Enter to add a space and create a new paragraph within as cell, when it is sent in…
-
Can update requests not be combined by recipient?
While I understand the benefits of a sheet's workflow combining multiple rows into 1 update request, if the email field for all of those rows match, is there a way to not combine and send an email per row, meaning a user may get multiple emails?
-
HELP with a large sheet and table layout/conditional formatting
I spent 15 hours trying to organize my data in an efficient way and just can't come up with a good solution. Smartsheet is great but SO limiting if you are used to Excel. I have 200+ sites that each has 31 activities. Each activity has 3 dates - planned date, reforecasted date and actual end date. I need a report that…
-
Private Comments
I am trying to figure out if there is a way to make a Private Comment in Smartsheet? Let's say I have a Published Report that is viewable to anyone with the link; however, I want to make a comment on a line that I don't want anyone to be able to view outside of the original document. How can I do this?
-
Can I add a specific row to an email from a workflow?
I have a smartsheet and there I will let people know when certain tasks have been executed. I have already created the workflow for that. My issue is when sending the email; can I add one row only on the email to notify that a certain task has been executed, so when I change one cell from "In Progress" to "Executed" a…
-
Can I get a notification when a new collaborator has been added to a sheet?
Hello, I have multiple sheets and dashboards created for different departments. We are allowing editors the ability to add collaborators to their sheets. I need to track who has been added as a new collaborator across all the multiple sheets so I can add these users in their specific groups (which grant them access to view…
-
Row Id in email
Hi! I'm trying to generate custom PDFs with a specific template from a smartsheet row. The workflow currently uses an automation to send an email when the row is "done". Right now, that email contains the "Row Number" which is the only way to identify the row through the API (all the rest of the columns can be duplicate…
-
Losing data when multiple users making changes at the same time
Hello, I am having the exact same issue as Thor did in 2015 - https://community.smartsheet.com/discussion/385/losing-data-2 I sent out a current user view report to my project managers and when they all update their individual rows/reports respectively, I keep losing the data in my cells. How do I ensure to get their…