-
Sheet row display error / mismatch?
Hi, I have noticed a strange formatting / display error caused I believe when text sizes other than "auto" are used. I have a sheet with conditional formatting that depending on a date in relation to today changes the font size (from auto to 14pt) to indicate that a critical date is approaching. I have noticed that the row…
-
Conditional formatting on linked date cells
Hi, I have created a sheet with linked date cells from another sheet but have found that the conditional test 'in the past' does not seem to work in the linked cells. I assume this is a current limitation or has anyone got any ideas to resolve this? Thanks Jacky
-
Conditional formatting for past dates dependent on other past dates
Hello, Is there a way to condtionally format dates in the past based on other dates in the past? For example, we are transitioning our project schedule from excel to smartsheet. We have dates in the past as shown below. In excel they are conditionally formatted to turn red if the Actual happened after the Current Target.…
-
Conditional Formatting Question
We use a Project Timeline Template that tracks the progress of each individual project. There are a number of parent rows with child rows beneath. I've created a status column so that each task can reflect the current progress via a harvey ball. I would like the parent rows to reflect the overall current status based on…
-
Conditional Formatting Based on Date / Number of Days
I have an sheet to track my employees. One of the columns is "Last Pay Raise Date". I would like to highlight a row when the number of days since last pay riase is greater then 180 days or something along those lines. Is that possible?
-
Help with Status and Date Columns
Hello, I am having trouble with a formula. I have 3 date columns, and 1 status column. I would like the status to change with the input of a date in the columns. Here is the reasoning for the question. I have "Ready Date", A "Start Date", and a "Complete Date". When a date is in the "Ready Date" column, I want the status…
-
Web Form Layout
In webforms I have to make each item a column that I want info to flow into. Can I make those column print inot a row later? A long row info from columns is too much.
-
Is there a way to copy a sheet's conditional formatting rules to use on another sheet?
I would like all of my sheets to have consistent formatting,
-
Tracking resources, their hours per task and their hourly rate
Using a standard project template, is there a way to track resources (licensed and non-licensed), their hours per task and their hourly rate. This way I can calculate their total hours worked x rate to get their cost.
-
Conditional Formatting - Target Dates vs Actual Dates
Hey guys & gals Basically I'm trying to get my actual task finish date to highlight green or red if it hits or doesn't hit the target date. I know I need a checkbox column to do this. I've added one with the following formula =IF(Finish2 > Baseline2, 1, 1) Finish2 = the first cell with the actual finish date Baseline2 =…
