-
Regularly emailed project sheet - how do I update the email body text??
I am a relatively newish user of Smartsheet and have used it about 3 months. A co-worker helped me to set up a regular email to be sent out to my team with my project list attached. The email body of that email that goes out needs to be edited. I can't figure out now how to go back and make any edits to that. Any ideas???
-
Automated Approval Requests
HI , I Have set up an Approval Request Which works amazing My only Issue is that my client that needs to approve the job Request Gets in his email for each Request line an email but its an auto Reply to the Previous Request Is there a way by the delivery settings to set that the subject of the email should always Reference…
-
Report on automatic email shares and reports
Hi, Is there a way to pull a report of what sheets within Smartsheets are being regularly shared through automatic emails as an attachment? Thanks, Dan
-
what is the best way to get rid of #DIVIDE BY ZERO ?
what is the best way to get rid of the results of #DIVIDE BY ZERO. I have tried conditional formating, but that doesnt work. I am not having any insight with the if formulas. Thank you, Jef
-
Timecard Approval by WEEK, not by line.
Hi Community! Relatively new to SS, so I am thinking this has a simple solution. We are utilizing the timecard template but need a weekly approval from management. As of now, I can only get approval request to work by row. I do not want the managers to have to approve each row of the timecard... rather, just one approval…
-
Drop Down Menus
Hello, I have a drop-down menu with a few selections and I want the next cell over to have a text based on what is selected from the drop-down menu. Can this be done? So on cell B3 I selected 5, and I want the word Tom to populate on cell B4 based on that selection. Thank you!
-
Why can't I change my email to merge accounts?
I mistakenly set up a secondary account and I deleted it so that I could add it to my other account. When I try to add it to my other account, I still get an error message that it's associated with an account. However, I'd already deleted that account! How can I fix this?
-
Transfer Ownership of sheets
Hello, I know that a user can take the ownership of several sheets one at a time, but is there a function where I can transfer ownership for specific sheets to a user?? Or that the user request a few or several sheets in one request? If not, I think that it will be a good idea to develop this feature. As an admin of the…
-
User-submitted forms: Is there a way to have email address and name be automatically added to my Con
I have an "Update Request" Smartsheet, where employees can submit a request via a form. The 'name' and 'email' fields are both required, so I'm capturing those fields on every submission. BUT even though someone enters an email address and name, I still have to manually add that person to my Contacts. How can I set my form…
-
Date Validation
I am able to limit date entry to only current month and greater but I need to allow an entry of last month date upto seven days of the current month. Ultimately I want to limit the date entry into a cell to only allow a past months date seven days after the current month. I would like to use Validation for this.