Total sum of results of a formula?

I have a formula to calculate payouts as follows:

=IF(AND([Estimated New Annual (ACV) Net Booking $ Amount]@row >= 75000, [Estimated New Annual (ACV) Net Booking $ Amount]@row <= 250000), "$2500", IF(AND([Estimated New Annual (ACV) Net Booking $ Amount]@row >= 251000, [Estimated New Annual (ACV) Net Booking $ Amount]@row < 1000000), "$5000", IF([Estimated New Annual (ACV) Net Booking $ Amount]@row >= 100000, "$10000")))

I would like to total this column so I can see the total payout, but it doesn't work and returns a value ZERO.

Is it possible to sum the total of the "results" of the formula above?

Find more posts tagged with

Formulas

Accepted answers

Jeff Reisman

@Desmond Smith

By putting your dollar values in quotes, you're forcing Smartsheet to create them as text values, and Smartsheet can't do math on text values. Remove the quotes and they'll be saved as dollar values, and then your sum will work.

Desmond Smith

That worked!! Thank you!!

All comments

Jeff Reisman

@Desmond Smith

Desmond Smith

@Jeff Reisman I took the dollar sign out and it still returns a "zero" value:

=IF(AND([Estimated New Annual (ACV) Net Booking $ Amount]@row >= 75000, [Estimated New Annual (ACV) Net Booking $ Amount]@row <= 250000), "2500", IF(AND([Estimated New Annual (ACV) Net Booking $ Amount]@row >= 251000, [Estimated New Annual (ACV) Net Booking $ Amount]@row < 1000000), "5000", IF([Estimated New Annual (ACV) Net Booking $ Amount]@row >= 100000, "10000")))

Jeff Reisman

@Desmond Smith The quotes, Desmond. Take out the quotes. The dollar signs can stay.

Desmond Smith

That worked!! Thank you!!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.