-
Conditional Formatting - Format based on comparison between cells not a Helper Cell
If I want to apply a conditional format to Column B on the proviso that Column B is greater than Column A, I must use a Helper Cell to determine if this is True or not. Like Microsoft Excel does; by including the ability to specify a formula to ascertain whether a Format should be applied would be a lot cleaner than having…
-
Need Help With COUNTIFS OR Formula.
=COUNTIFS([Timeline Prioritization]:[Timeline Prioritization], "Now (1/1/24-5/31/24)", [System Status]:[System Status], "In Progress") That formula is to count the number of cells that have "Now (1/1/24-5/31/24)" in the Timeline Prioritization column while also have "In Progress" in the System Status column. Based on the…
-
Conditional Formatting Referencing Other Columns
I would like to see conditional formatting rules that can be applied to other columns. For example, we have two columns for each of our KPIs. One column reports the target turnaround timeframe. The other column reports the actual # of days it takes to complete an item. For our surveys, our target turnaround timeframe…
-
Conditional Formatting Grid vs. Card View
Hi - I tried to set up conditional formatting for a new sheet. I've done this with other sheets with no problem. I want to color by category (entire row). however, the colors are not showing up in Grid view, only Card view. I have no idea why this is happening. I thought it might be in the settings but it doesn't appear I…
-
How to Sum (Distinct Value Column 1 * the Qty in the same Row) + the Count of distinct in Column1
I am trying to create a formula that will Sum the (Distinct Value from Column 1* the Qty in the same Row) + the Count of distinct values in Column1 for a total to be calculated in another Sheet next to the Distinct value. There may be an easier or more straight forward way to do this but I am not sure. Below is an example…
-
PSA: Conditional Formatting Stopped Working
I went through hell trying to figure out what is causing my conditional formatting to suddenly stop working when it was working perfectly in the past. My sheet is shared by 104 people. After many hours scratching my head and calling support we figured out the issue. SOMEONE TURNED ON HIGHLIGHT CHANGES and made the…
-
Conditional Formatting - If date entered is prior to another date
I'm looking for a way to set conditional formatting to a date field on our Smartsheet. Currently we capture "Date Submit Legal" and "Date Legal Approved". I would like to find a way to change the font to red if the approved date is prior to the submit date. Since this is a manual field we are finding on occasion the date…
-
Making sheets from a sheet
I know how to copy info from one sheet to another sheet. My question is...I've created an Application form for my employees to fill out. Is there a way to set up where a new sheet is created for each applicant and copies their info to it also. Meaning...Joe Smith fills out my application - then Smartsheets creates a brand…
-
How do i set up a conditional format, when i want more than one person in the assigned to column
I have each assigned to person with conditional format with a color to let them know what they are assigned to work, but what if i need two or more associates to work that particular assignment, how do i set up conditional formatting for that, or would that be a formula?
-
How to Format Date-dependent Color-changing Cells (3 total columns)
I need to create a Smartsheet for tracking documents, the date of last review and a color changing column reflecting the date of next review. In column A I need to list the document names. In column B I need to list the date of last review. I need help to format column C cells. 1. I need for Column C to populate a date…
