Tag Info

Hot answers tagged

1

It sounds like you shouldn't use a calculated column at all: It would probably be easiest to use the workflow to set the field value when that intermediate step is complete as is sort-of suggested in your link; to get it working in your situation you need to make the column you're using as a calculated one now a date or text type, then make a workflow or ...


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