-
Conditional Formatting Help
Hello, Can conditional formatting achieve what I'd like to do, and if so, how? I'm coming up short and would love help. I have a daily task list for projects I'm working on. I would like to have the row turn red if the due date is 3 days away and the status column shows anything other than Complete. Is this possible? Thank…
-
Is there a way to get custom color conditional formatting in smartheet?
-
Alert or update if a column value is changed based on the column(primary column)
Example - I've columns warehouse and route . I need to setup a notification or alert if the route had changed for a particular warehouse. In this example , I need to send notification or alert for Test and PR103 as the previous values of route has changed for them. can someone guide me as to how to do this?
-
COUNTING @ ROW LEVEL
Hello, I'm looking for a formula/solution that would count all the correct answers at a row level. If the answer is wrong then it wouldn't count it. Any suggestions? Maybe Conditional Formatting to denote wrong/right answers. Ive tried multiple formulas. I'm stuck. Please let me know if you have any additional questions!…
-
Conditional Formatting not applying consistently
I have a sheet with conditional formatting rules so that if there is a "0" in a cell the text will be gray and if there is a negative number it will be red. If I close the sheet and then open it again the conditional formatting does not show, but if I go into the setting and basically pretend to change the formatting it…
-
Formula and Color Change in Cell
Hello, I am wondering if it was possible for the "Initial Risk Score" cell color to change when the "Probability" and "Severity" is selected? I currently have the following formula in all cells "Initial Risk Score" =IF(AND(Probability1 = "Improbable", Severity1 = "Negligible"), "1", IF(AND(Probability1 = "Improbable",…
-
IF Statement between Ranges
Hello, I am not sure what i am doing wrong in the formula =IF([Current Risk Score]@row < 15, "36 Months", IF([Current Risk Score]@row > 70, "3 Months", IF(AND([Current Risk Score]@row > 16, [Current Risk Score]@row < 29, "12 Months", IF(AND([Current Risk Score]@row > 30, [Current Risk Score]@row < 50, "6 Months"))))))…
-
Help with conditional formatting
I would like to set up conditional formatting so if columns Original SeqProj Name and New SeqProj Name DO NOT match, New SeqProj Name turns yellow. Example done manually below: I thought I could achieve that with the following conditional formatting rule: As you can see, it also highlights the cell where the two columns…
-
What formula can I use to count both the blank spaces of a column and the data from another column?
I want to count the blank spaces of a column titled "completed" where the cells are either blank or have "yes" on them, while at the same time counting the cells of another column in which the cells are blank, "enrolled" and "waitlisted"
-
How do I make a column formula that automatically checks the box if another column contains 1.
I am trying to make a checkbox column automatically check its box if the column1 contains 1. It may be equal to one but in some cases, it could be 1 high or 1 low. How can I check to see if the cell in column 1 of the same row contains 1. I have tried =CONTAINS(1, column1@row), but the boxes aren't checking.
