Could you help give a solution that find the column 3&4, if the data is the same, mark the both lines, thanks
Hi Christy Chen,
As per the condition, you can create a helping column and apply the following formula:
This formula will count the number of times the value in column 3 is repeating.
and then you can apply the conditional formatting rule -
This will work as, when the data is the same, it will mark both lines.
I hope it will work.
Hi, Does anyone know if there is a way to send an alert if the value in a cell changes by more than a certain percentage? So, if I have 100 in a cell (text/number) and the value changes by over 5%, I'd like to be able to send an alert. Thanks, Vince
I'm sure this is super simple but myself and a colleague could not figure it out. I have some very simple data I need graphed for a project: Not Started, In Progress, Complete and then % Complete using the total. The pie chart for the Not Started etc. comes out correct: But when I ask it to graph just % complete, it does…
Hello, I am working on a training log for our company. I am trying to get the status color to turn green if training is completed, yellow if it is due in the future, and red if it is incomplete. I keep getting an incorrect argument. I had it working correctly when I was just doing red and green, but I really need that go…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.