-
Default Sort for Email Reminders?
What is the default sort for email reminders? I have an Automation set up that has "Sent to specific people" and goes to multiple people, some of whom are within the Contact column. I want to customize the sort of the Contact column so it's easier for the users to find their information quicker and easier. I have to send…
-
Auto formula Sum is generating a 0 when no data is present yet
I have a column with an autogenerated formula looking at turnaround time. Essential day completion minus day start. Somethings are finished the day of and have a turnaround time of 0 days which is great for us, however, for rows that do not have a finish date yet it is auto generating a 0 instead of what should be a blank.…
-
Smartsheet Automation - Request an Update
Hi There, Is there a way to request an update to a team, but only have them able to edit selected items and not the full sheet? They still will need all the information, but want to minimize the risk of errors.
-
Automatically move a sheet within a sheet?
Hi. So I have created a production sheet that displays all my projects and where they're at in its state (Phase 1 through Phase 5). For example: Phase 1 Projects: Project 1 Project 2 Phase 2 Projects Project 3 Project 4 Phase 3 Projects Project 5 Each "project" is a hyperlink. When clicked on, it sends the user to the…
-
help to run holidays for all our staff
Hi all I need some help, im trying to use smart sheet to run holidays for all our staff. I have a main source sheet for all the staff where all the calculations are taking place. i then have separate department sheets running with booking forms. I want to introduce a booking pin to avoid spamming. This would have a file…
-
Update Request email text is not sending
Hello. I have an automation setup to send update requests to others in my team. The automation itself works fine with the conditions that I have outlined, but the issue is that the email notification text I have entered doesn't send to SOME of the recipients. We are all in the same org. This is causing a problem as I have…
-
Sending An Update Request after 30 Days
Hello! I'm trying to send an update request to be alerted during the following time periods: 30 days after the initial row was added 60 days after the initial row was added 90 days after the initial row was added I have an "entry date" field to build off of to serve as the date the row was added. Is there a way to do this…
-
Automation Email Attachment Options
Hello, I am not sure if this is even possible, and not normally how the automation process is used, but its worth a shot. Is it possible to set up an automation to email someone form a contact column, with the email containing information from another sheet when a form is submitted? For reference, the security company I…
-
Can we decide who receives emails when the comments are added?
I use Smartsheet as a request system for our team. We will have tickets that are assigned to the members of our team and the tickets are submitted by anyone. I want to customize who received emails when the comments are added. For example: If the person who submitted the request (Requestor) has added comments, I want an…
-
Automated email subject line text
So, if you automate emails (workflows) and forgo customizing the message, the email title is autogenerated as follows-- For Alert Someone: Changes to [title of sheet]:[primary column text] For Update Request: Update request for [title of sheet]:[primary column text] However, when you customize the message, you can assign…