Populate Countersign Conditional with airSlate SignNow

Concatenate conditional field pdf

all right in this video I'm going to show you how to concatenate a list of items in a range based on some given criteria so in this example I've got a list of people and I want to produce from that a list of the people where this column has yes in it so although all the people that were invited if I use a helper column so and I do a formula like if invited equals yes and give me the person and otherwise just return an empty string and if I copy that down and that's gonna give me the the list of people that are invited and then I can do something over here like text join and maybe a comma as a delimiter and then I'm gonna want to ignore those two empty cells so add true in there and then just reference my list of people by hit enter that's gonna give me the list that I want with commas in between all the people but we can avoid this helper column if we use an array formula so if I do something like this if I edit this to be if this range yes [Music] I'm just gonna delete this then give me my person otherwise just give me an empty string that's not actually gonna work because the if function is not an array function so it's not gonna return this it's not gonna return that array that I want but we can turn it into an array function that will return our list by using control shift and enter to enter this function and that's gonna give me the result I want and we're not actually using this helper column so the formula works without that and that's how you can use her saree conditionally concatenate a list of items based on some given condition using an array formula with text join and if