Hey, it 's me again. So I was able to further develop our model. We can now enter Holidays in one table and it automatically transfers them to our holiday calculation model via lookup fields. The fields look like this now:

So: We enter the Holidays in the Table âholidayâ Link them to the field Employees, so that every time a new holiday is entered the name and the numbers are automatically transferred to this table.

I also linked the Employee field to our Holiday Calculation to be able to deduct the sum of the days taken from the total holidays available, which are schon in the first field âverbleibender Urlaubsanspruchâ:

Now I tried summing these days with two different approaches:

First I tried to Sum the days looking up the values in our employees sheet using:

sum(lookup(âMitarbeiterâ,âUrlaub in Tagenâ))

Sum(lookup(âMitarbeiterâ refers to the employees table because Mitarbeiter is linked to employees and âUrlaub in Tagenâ refers to the days counted in this table. However, I get the following error:

*Error with formula: argument number 1 given to function sum was of type array but the only usable type for this argument is a list of number values obtained from a lookup or link row field reference.*

Is it not possible to sum a field in another table via this function? This would be my favourite option, because then I dont need to create the same lookup fields in the holiday table, which I already created in the employee table just tot sum the days.

Anyways, I also I tried to use: sum(field(âUrlaub in Tagenâ)) to simply sum the lookup field which I already created in this table. However now I get the same error:

*Error with formula: argument number 1 given to function sum was of type array but the only usable type for this argument is a list of number values obtained from a lookup or link row field reference.*

I dont understand why the sum funtion does not work here. I used it the exact same way before, and I checked the formular 10 times and canât see what is wrong. Maybe youâll be able to help me once again

Thanks so much!