Tag Info

Hot answers tagged

2

Okay, I solved it. And you can't tell me it doesn't work, because I can see it with my own eyes :) So, that javascript you are running from that guy is unecessary, and it makes things more difficult that they should be. So you have three columns. One column has the status, one column determines the color, and the final column has the div tags. And it's ...


1

Okay, this is a very verbose answer, only because I cannot think of another way around this. I will try to answer this as easily as I possibly can (no offense to you, I don't mean to make it sound like I am trying to speak down to you, it just involves a lot of steps that involve arguments that will be different for me as they are for you. To answer your ...


1

Just add a conditional check for column A to be blank. =IF(A<>"",CONCATENATE(A,", ",B, " feet"),"") If A isn't blank, it'll return the concatenation, otherwise it returns an empty string.


1

=IF(AND([Task Name]="Task 2",Completed),1,0) Figured out with help from Tiac


1

Try this function, should work. =IF(AND([Task Name]="Task 2;[Status Field Name]="Completed");1;0)


1

It introduces other complications, but your best bet may be a lookup field. Create a secondary custom list called Countries. Then build a lookup column in the first list which references the Countries list values. Now your example will work the way you intend.



Only top voted, non community-wiki answers of a minimum length are eligible