Display a Result in Percent and Division
Options
Hello,
I currently have a sheet that counts a quantity of total on time (YTD) and total overall, referenced from another sheet. And then I have another column that takes this two values to give me a percentage. I have a table that shows me the percentage based per month, you can see it the upper table), the second table is an example of what I'm trying to make, which show the percentage and the fraction (which I did t manually), is there a way to make the first table look like the second table without entering the data manually?
Answers

=[formula 1] +char(10) + "("+[formula2]+")"
should get you close. if formula's are looks to other sheets then use index(Match) formula
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!