How to add text from one formula to the result of another formula

Hello,

I have two formulas.

1) calculates how many validated units there are. The result is 600.

2) calculates how many units there are in total. The result is 1200

I would like these formulas to combine so the result is 600 / 1200

I am aware I can use +" 1200" but this number will keep changing and the total number to update automatically in the combined formula. Is this possible?

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

You would write it out the same way but you would use the second formula in place of the hardcoded number in quotes.

=formula_1 + " / " + formula_2

All comments

Sam Swain

Correction: I am aware I can use +" 1200" but this number will keep changing and I would like the total number to update automatically in the combined formula. Is this possible?

Paul Newcome

You would write it out the same way but you would use the second formula in place of the hardcoded number in quotes.

=formula_1 + " / " + formula_2

Sam Swain

Thanks Paul!! Works perfectly!

Paul Newcome

Happy to help. 👍️

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.