-
Conditional Formatting Duplicates
Hello, Is there a way to conditionally format duplicates if a value is in a column and if a box is checked? I need this to look through the whole sheet where there are many input values by the customer via a form. Thank you. Brian
-
Auto Delete rows
HI, I would like to know please what will be the best way to delete rows which their time stamp i more than 24 hours. i can't find a delete function under the conditionl function.
-
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…
