- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 28, 2023 03:44 PM
Hello! I figured this out before and accidentally cleared it a while back without noticing. For context, I am trying to find the total cost associated with ordering additional curriculum books.
In the form submitted, customers can select additional books for purchase at $45 for K-2nd and $60 for 3rd-6th.
I am trying to find the sum of:
multiplying the following columns by $45: Additional K English, Additional K Spanish, Additional 1st English, Additional 1st Spanish, Additional 2nd English, Additional 2nd Spanish
multiplying the following columns by $60: Additional 3rd English, Additional 3rd Spanish, Additional 4th English, Additional 4th Spanish, Additional 5th English, Additional 5th Spanish, Additional 6th English, Additional 6th Spanish
for a total cost to appear in "Additional Books Purchased:"
ex: 1 additional K Spanish & 1 additional 6th English would equal $105 in the additional books purchased column.
Any help is greatly appreciated!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 29, 2023 01:28 AM
Hi @tarincook,
Is the selection of books a multi-select or a linked record?
Ideally, it would be easier to manage books and calculate prices if there is a book table, with selections made by link record, and prices set for each book.
If multi-select, you would need to condition all book names with a formula.
