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


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!