-
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.
-
How do I change a user's login name
What is the correct process for changing a user's login name after they have a name change (marriage, incorrect spelling when created, etc) I see I can change the first name / last name, but I'm not able to find out how to change the login / email address.
-
See what groups a contact is part of
Hi, Is it possible to see what groups a smartsheet user is part of from the smartsheets contacts view? I am looking up some of the users in my account, and it would be much quicker if I didn't have to look through each group to see if they have access to it. Thanks Dan