-
Custom View on Grid/Gantt
Often when I setout a new schedule layout I end up with a number of columns either auto- calculating, which I subsequently hide, or tracking finance, progress, comments etc and the view is busy... I'd love to be able to Save custom views, so I can select chosen columns to view. IE. Custom View 1 - Finance. Shows me the…
-
Update Request (form) 'Quick Button'?
Hi I have a large team of people updating a number of sheets. Within the sheets are a number of rows (risks and issues), each one has it's own ID. Whilst the sheet is shared and I have some of the columns locked, I want to be able for a user to review their risks and issues and then to click an 'update' button so that they…
-
How can I write a formula to summarize in parent row summaries in child rows?
Column is entitled Status and is a drop down list with the following selections: Not Started In Progress Delayed Cancelled Complete I have a formula in each child row to summarize grandparent rows: ="Not Started (" + COUNTIF(CHILDREN(), "Not Started") + "), In Progress (" + COUNTIF(CHILDREN(), "In Progress") + "), Delayed…
-
I would like to hire an experienced consultant
I am relatively new to Smartsheet. I need someone to help setup Smartsheet to manage our book production schedule. We publish books (print and e-) and have managed our production schedule for many years with a Google Sheet. It is severely lacking. I have not yet signed up for any plan. I don't think I'll need 3 licensed…
-
The Time it Took to Perform a Particular Action
Hi, I realize the questions is quite vague, but is there any way to show/calculate (this need not necessarily be done via a Report as the word is used in Smartsheet terminology) the time it took for somebody to complete a certain action. I,e. let's say there's a task that somebody is assigned to and they begin this task by…
-
Finding cells that aren't linked
Hi everyone. I have created a mastersheet (A dashboard), where i link cells from 10-15 other sheets (Project sheets). What i want to do is to create a report, that will "catch" any rows that are added withing the project sheets. Basically what i want to do is to keep my Dashboard up-to-date when changes happen in the…
-
Highlighting changes on a sheet
If I highlite changes done to a sheet for me within the hour or so, will this rule show up for others or does everyone need to setup this highlighting feature themselves?
-
Adjust column height
How can I adjust the height of the columns in SmartSheet? The column height is so narrow I cannot view the entire title.
-
Current date against a ticked checkbox.
Hi, I'm trying to come up with a formula that will populate a given cell with the current date if and when a certain checkbox has been ticked. Please note, this date must be fixed, i. e. it must NOT change as the days go by. Is this possible at all? I know this is completely wrong, but just to illustrate better what I mean…
-
Move to Completed
Our team is using the Team Tasks by Priority template. Is there a way to automatically move completed tasks under the completed hierarchy?
