Hot answers tagged calculated-column
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 ...
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.
=IF(AND([Task Name]="Task 2",Completed),1,0) Figured out with help from Tiac
Try this function, should work. =IF(AND([Task Name]="Task 2;[Status Field Name]="Completed");1;0)
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