Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Row Colorization
Is there a way to set the color of a row based on a formula more complex than the Case statement?

For example, if any of three columns = "No" I want the row to be Red
Additionally, if a 4th column is "No", then I want the row to be Gray, regardless of the settings in the other 3 columns.

I can do one or the other easily with Case, but I haven't been able to figure out a way to combine them.

Any help or pointers would be appreciated.
Thanks!
ID
947
Category
Customization
Author

Dave Loverink
Date Created
1/19/2016 3:34:52 PM
Date Updated
1/19/2016 3:53:27 PM
Comments
Slava Shinderov  Staff  1/19/2016 3:51:33 PM
Please try following formula:

If([Column 4]="No", "gray", [Column 1]="No" or [Column 2]="No" or [Column 3]="No", "red")

Learn more here:
https://www.teamdesk.net/help/13.2.aspx
cooper collier  1/19/2016 3:53:27 PM
You can nest if and case commands. Just use code formating to make it easier

if ([column1]="cars",
//this is the true section
if ([model]="ford", red, blue"
,
/ /this is the false
if([model]="chevy", green, blue)
)

I do not see any reason to not next case commands
or nest case and if..

you just have to pay careful attention to formatting, but you can use comments and indents and returns for that.

NOTE: if you copy a formula from the page where you display all the columns then copy it to a new formula column, it tends to mess it up, when copying formula, I do it from edit to edit screens.


Feedback
Back to Search Results