-
Trouble Changing permission in a sheet from Viewer to Editor
Dear all, I have changed a collaborator in a worksheet from viewer to editor - can share. I can see this has updated as can the other contributors in the project. However the individual is not seeing the change in his system and he is still unable to edit the project worksheet. After 2 days the SS Helpdesk has not…
-
Autocomplete data entry like Excel
I simply want to have Smartsheet autocomplete my data as I enter it in a cell as Excel does. Is there a way to turn this on?
-
Create Automation based on Multi-Select Drop Down
Hello I have a form where people can select what events they want to attend based on multi-select drop down option. Some of these events have a maximum capacity. I have set up formulas to count how many people sign up to each event. There are a couple of other things I want to do based on when maximum capacity is reached:…
-
Project sheet
Hello, I have created a 'simple' project sheet to track loaners. A few questions: when updating "Assigned to" I see the same person's name appears on the calendar side (right). Does that mean that a reminder will be automatically sent to the person on the "Finish" date? the duration was calculated on the first row, but not…
-
Transfer data from one sheet to another
I know SS has the "move to another sheet" or "copy to another sheet" but sadly it does not look like you can do that and have "cell links" from the blank form that you are going to copy data to , to do other items. Does anyone do any copy / pasting that is advanced and would have some suggestions? Here is what I am doing…
-
How to do a sheet report
I am looking to conduct reports that I can send to my manager based on task that are open, pending or in -progress. I also, if I need to apply a formula, I have problems understanding the (what if, or If this then that) structure. Thank you for your help Iris
-
depanedant dropdown list in smartsheet forms
Hi all, as discussed here https://community.smartsheet.com/discussion/38196/dependant-dropdown-lists I am looking for the ability to have an depandant dropdown list in smartsheets forms. e.g. if the employee select his company only the associated departments should be shown to be selected. By the way, appsheet…
-
Best practice for formulas and rolling out templates
Hi folks. It strikes me that Smartsheet HAS to be set up right from the get-go, because if you get your template wrong and roll it out to your users, adjusting a formula, column name or any other duplicated variable is going to be a big pain to fix - you'd have to have all your users transfer their data onto your new…
-
I cannot give editing permissions to my colaborators
I'm having trouble with giving permissions to my colaborators to edit my sheet. I give the permissions with the top-right button in the sheet (no trouble with that), but when my colaborators log-in with their personal accounts to edit the sheet, they find only visualization permissions. I've tried everything, from changing…
-
No built-in search icon on sheets?
Good morning, I feel like an idiot, but our sweet elderly volunteer called to ask me if there is no longer a search function in the sheet...sure enough, I cannot find a search icon/option in the icons on the sheet, or in the File drop down. Am I just missing it? If not, why isn't there such, as search is a widely used and…
