You will find that you can just do it similar to excel and you don't need to use SUM.

Just

[field 1] + [field 2] + field 3] + [field 4]

------------------------------

Mark Shnier (Your Quickbase Coach)

mark.shnier@gmail.com------------------------------

Original Message:

Sent: 09-14-2023 13:28

From: Awe Maggie

Subject: How to use sum formula

No worries. I got it.

Thanks!

------------------------------

Awe Maggie

Original Message:

Sent: 09-14-2023 12:41

From: Mark Shnier (Your Quickbase Coach)

Subject: How to use sum formula

OK, I see the screenshot and you were showing me a bunch of numeric fields. Are you now asking how to make a new formula numeric field which uses those fields in its calculation? Are you stuck on the formula for that numeric formula field? If you can say the formula in words we can help you with the syntax. Or if you have a formula which is not working and you copy and paste it (not a screen shot, but a copy paste) we can help de-bug the formula.

------------------------------

Mark Shnier (Your Quickbase Coach)

mark.shnier@gmail.com

Original Message:

Sent: 09-14-2023 12:29

From: Awe Maggie

Subject: How to use sum formula

Thanks!

See the attached screenshot

------------------------------

Awe Maggie

Original Message:

Sent: 09-14-2023 12:16

From: Mark Shnier (Your Quickbase Coach)

Subject: How to use sum formula

You should be able to create a field of type formula numeric (ie not simply numeric).

If you say in words what your calculation needs to be we can help you with the specific syntax.

------------------------------

Mark Shnier (Your Quickbase Coach)

mark.shnier@gmail.com

Original Message:

Sent: 09-14-2023 12:07

From: Awe Maggie

Subject: How to use sum formula

I am trying to use the sum formula and the formula is looking for the number, but the data field types I was trying to add are numeric with dropdown number options.

------------------------------

Awe Maggie

------------------------------