How do I make the numeric value returned in this formula usable in other mathematical formulas?

Value returns correctly, but I need to be able to add that value to OTHER formulas and fields.

=IF([Target Level:]@row = "Standard", "$19,000", IF([Target Level:]@row = "Superior", "$100,000", IF([Target Level:]@row = "Premier", "$240,000", IF([Target Level:]@row = "Elite", "$490,000", IF([Target Level:]@row = "Platinum", "$875,000", IF([Target Level:]@row = "Presidential", "$1,500,000"))))))

TIA!

Find more posts tagged with

Formulas

Accepted answers

All comments

Brent Wilson

1) By using "$240,000" in the formula Smartsheet sees it as text.. it sees it as no different than "Hot Chocolate". So you want to type 240000 and let the formatting of the column change it to $240,000

2) Try this:

=IF([Target Level:]@row = "Standard", 19000, IF([Target Level:]@row = "Superior", 100000, IF([Target Level:]@row = "Premier", 240000, IF([Target Level:]@row = "Elite", 490000, IF([Target Level:]@row = "Platinum", 875000, IF([Target Level:]@row = "Presidential", 1500000))))))

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.