-
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
-
Public Holidays
Hi, When we update our public holidays, it doesn't seem to pull through on project plans that were created 2017. Can someone please advise how we can get smartsheets to automatically update projects plans that were created in 2017 with 2018 public holidays? Please note that I have updated smartsheets with the latest public…
-
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.
