Once a line item (row) is marked YES complete, can that entire row (with or without formatting) be moved to another sheet so that it is not shown on the in-progress/working sheet? Or... can I move an entire row within the sheet if a specific column is marked such as conditional formatting. Thanks
Hello, Is there anyway to default dependences so that when you start a new project sheet the dependences are already set? I am currently setting up multiple projects and having to enter working weeks, hours per day and holidays is quite time consuming.
Is it possible to define a default condition on sheets so alternating rows are shaded? This would improve our readability. Many people add to this sheet, so creating them manually is a major pain.
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…
I have a large sheet (48-50 columns by 80 rows). I can not see the last column. It has a formula that displays either "not done" or "done". I use it to highlight "done" rows in green. I was working on another indicator and wanted to access that column and couldn't scroll over to it. Have I met a limit on the width of the…
So I set my project so that working days are Mon-Fri. However I want to make an exception on a specific Saturday, and make that a work day. Is that an option?
I've been using smartsheets for projects plans for some weeks now and can manage all of the usual functions that I'm used to but I've got a new challenge. How do i add variable contigency to the duration of a task based on a BRAG status? Example: In an Agile development environment the first pass estimate is RED and should…
On my Entresto PPEP 2016 Sheet-- When I expand line 46, everything beneath it is lost. How do I fix this?? Thanks!
is this possible? Example: Child rows start hidden. If a column in a parent row is checked, the the child row is made visible. More info: I am trying to create a type of set up where I can use a sheet as a form where if the person enters "yes" in a cell, I an guide them to answer the next in a series of questions. This is…
We use Smartsheet for a number of different departments, HR being one of them. I'm wondering if there's a way to conditionally format a "hire date" cell to change colour when an employee anniversary is approaching? There is currently an option to conditionally format for a date that is a certian amount of days in the…
