Sum 3 formula field results

I am so, so terrible at wrapping my brain around formulas, so I’m sure this is actually a very easy thing. :melting_face:

I have 3 fields that are giving count results for 3 other fields. 2 of the fields are counting linked records, and the last is adding up values. I need to add them up to a FINAL total.

Once someone points me in the right direction I’m sure I will facesmack my keyboard because it makes so much sense lol Thanks!!!

:wave: @Shannon_Bradley

the formula you’re looking for is Sum().
Please see the coda formula guide link below.

hope this helps!
Cheers!
Mel

1 Like

Just that?!?! I must have been bringing something in wrong, because I swear I tried that. I think my problem is that I am coming from Airtable, and formatting works differently.

Well…off I go to be embarrassed in a corner! Thanks!

Don’t worry, there is a lot of us in the “embarrassed corner”…

1 Like

:wave: @Shannon_Bradley

Nah no embarrassed corner here in community forum !
We were all at where you were and those before us (the OGs) helped us heaps !!

Also im from Airtable world as well… 4+ years power user and even tho i had very strong DB architecture and formula skills… err… nothing prepares you for Coda :sweat_smile:
Def keep chugging along… keep learning and steady wins the race!!

Cheers!
Mel

2 Likes

I imported an entire convoluted base, and fixing things has been fun. Especially when I can take something that used to be a 4 field workaround and make it a single field… :zany_face:

3 Likes