-
Shared To Me and grouping sheets/workspaces
Right now I have about two dozen sheets shared to me. That number is about to significantly increase... because the people that are sharing the sheets with me work on different projects, is there a way to "view" or "group" my shared sheets other than by clicking on the Location or Owner header to sort? Say, one group for a…
-
Help with Duration by assigned to formula
I need to sum the duration colums by assigned to if the status is complete. I am having so many errors when trying to do this. Can anyone help?
-
Smartsheet Academy videos not working properly
Hello, have reached out to Support but haven't been able to find a solution to this other than ensuring my browser/Flash/etc are up to date, which they are. Wondering if anybody else has purchased the Smartsheet Academy course online and has been able to view the videos. They won't load initially for me - sometimes they do…
-
How can I get Calendar view info to wrap so it can display more than 20 characters?
I want to be able to show more than the 20-25 characters limited in the display of a calendar entry. e.g., I need to be able to show an "Issue No. (10 characters) + an Impact" which can be a list of multiple things. I would not mind if it wraps around into a second row as long as it displays all the information needed by…
-
Highlight a column on the calendar (Gantt)
Currently I have the ability to manually add holidays to the Gantt view, which default as non-working days. I would like to be able to mark a calendar das a WORKING or NORMAL day, but still have it highlighted (in a color of my choice) on the Gantt view. Ideally, I could even add a description that would show if I move my…
-
Star Ratings/ Symbols - changing amount?
Hi, I have a sheet where we want to monitor the value of a project simply with a 1 to 3 star rating, but the only star symbols available are either an on/off, 1 star symbol, or a 0-5 star rating. Is there any way of reducing the mount of stars to simply 1-3, or is there a formula (similar to the RYG ball) to show this? I…
-
What is the best way to consolidate data from multiple sheets to a single row
Hi, hope someone can help me. I am using smartshheet as an internal onboarding process. This process requires me to collect data from 2 webforms entry for same client that autofills 2 different smartsheets, one smartsheet with about 20 colums and other with about 35 columns, OR a single webform to a single master…
-
Reporting tool for invoicing
I run a consulting company and would like to build a sheet where the staff can report on the time they have worked for certain clients. We invoice AM and/or PM blocks, not per hour. I have my clients in a drop down box. How can I make a summary sheet that links to the individual consultant reporting sheets in order to…
-
Children Selection Using Keyboard
I usually need to select all of the children to copy and I have to use the shift+mouse to manually select them. Keyboards should be faster, but in Smartsheet, Ctrl+Shift+ArrowUp/Down will select past the parent or to the rest of the sheet if there's no blank rows between each parent. Can the Smartsheet team update the…
-
Feature Request: Row Summary Documents
Our business utilizes Smartsheet in so many ways. One feature that continually wish Smartsheet had is what I call a "Row Summary Document". This feature would essentially mimic the Form builder already contained in Smartsheet, however it would be in reverse. The form would actually be populated based on an already…
