-
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…
-
Vacation days formula; how to allow for half-days (or holidays)
Not having a lot of background experience with formulas, I am having difficulty determining whether or not the NETWORKDAYS formula can be "adjusted" to include an allowance for half-days. Using the Vacation template, it calculates the number from start to end days. I have added a check-box column for half-days. If this…
-
Expanding a line and losing any lines beneath it.
On my Entresto PPEP 2016 Sheet-- When I expand line 46, everything beneath it is lost. How do I fix this?? Thanks!
-
DATEONLY Formula Error Message
I cannot get my DATEONLY formula to work. It keeps giving me "missing or invalid parameters" as the result. I am trying to create a formula that gives me a date variance between Planned Start and Actual Start. My two column names are Planned Start and Start and I am trying to start in row 5. This is the formula I have and…
