-
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
-
Smartsheet Merge Permissions Issue
I'm on the trial version, but will definitely upgrade to paid versions for our company. One of the most important features for us is the Google Docs Merge functionality, but I'm having trouble installing Smartsheet merge. After add-on install, I hit "Connect to Smartsheet" and it takes me through various permissions dialog…