File size formula

1

Hello,

Could someone explain to me how this formula works in one of my old tables? It shows an error, but it still calculates the total correctly. However, I can’t get it to work in any other table.

image
image558×402 23.2 KB

image
image260×136 4.57 KB

2

You can see that Size is treated as text so that’s why it says is wrong argument type. Try Size.ToNumber()

2 Likes
3

I don’t have a column with that Size name in the table at all.
It’s a mystery how it works :smiley:

image
image352×930 33.5 KB

4

Are you suing any packs? The FILES column content (images in this case) is local or you pull those images from another table?

Please share a dummy doc.

5

https://coda.io/d/_dLNaX2etUIH/Sample_suL4nfwb

6

I’ll be dammned.. I have no clue. Maybe you just copied by mistake the Size column chip from another table. I don’t get that column in suggestions. Check within the doc maybe you have it somewhere in another table but anyway… it’s a weird thing.

7

this is mysticism.
I think I once saw some hack somewhere here in the community how to enter it and it works, or maybe the code changes the shape to some extent and later it doesn’t work or something.

But at least everyone who copies this table can calculate the file sizes for themselves, there is no such option in the default.

8

it looks like each file in the FILES column has a Size property

9

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.