Help

Sum of manually entered values in a single field

442 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Fabio_Bracht
4 - Data Explorer
4 - Data Explorer

Hello!

A simple issue:

I have a single line text field I populate manually with values related to my work throughout the day. At the end of the day, it may look something like this: 297+75+8+23+34+64+18+50+53.

The next field after this one is supposed to be a sum of these numbers. In this case, 622. I have been doing this sum manually, outside of AirTable, and just pasting the number.

Now, is there any way to compute this sum automatically?

I know I could do this if each number to be added was its own field — then I could select a range of fields to be added together. But I don’t want to have that many fields in my records, it’s not needed. Plus, some days I need to add just three or four different numbers together, while on others I need to add more than thirty.

Can anyone help, or am I already doing this the best way I could?

Thanks!

0 Replies 0