Autofill different columns with different input data, but only until a specific row number

Question

I have several rows that I would like to autofill with different input data.

I used the formula tool to fill the rows. 994 rows are filled with this input data (I don't know why 994 exactly).

However, I only need 20 rows to be filled as only row 1-20 contain data.

Can you help me to adjust the formula to only fill a specific number of rows (20) and not more (994)?

Appreciating your help. Thank you.

Christine_Assaad · Answer

Hi @T_Lina

If there is a field that has always to be populated, you can write something like this;

if !isempty([Field1]) then "X" else "" endif

So basically, you are dynamically checking if this field (row) is populated, then it will go and fill the newly created cell with X value. If not, it will leave it blank.

Hope this helps. Cheers!

AngelosPachis · Answer

Hi @T_Lina ,

You can achieve that by using a multi-row formula. First, I would use a record ID tool to assign a unique ID in each of my tools. Then through the multi-row formula, you can say that if your Record ID is less than 20, then assign the input data you desire (in my example, I used the Field1 field)

Observe how my Top 20 records field is populated until row 20, although there are more data in Field1 past that.

Hope that helps

Regards,

Angelos

example.yxmd