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?
Best Answer

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
Answers

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?

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

Thanks Paul!! Works perfectly!

Happy to help. 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!