-
Conditional formatting rules and user-based formatting
Hi, If I set up a rule that all past due dates are color-coded red, but somebody else goes in and changes the text color to blue, will it override the conditional formatting? Can I lock it so that it can't be changed? Thanks!
-
Once 'complete' can I move an entire row to another created sheet
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
-
Holidays over multiple projects
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.
-
Shading alternate rows
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.
-
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…
-
Last Column not available for view. -- recovered!
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…
-
Non-Working Day Exceptions
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?
-
Contingency based on BRAG status
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…
-
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!
-
use conditionals or formulas to show or hide child rows?
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…
