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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!