convert a fraction to a decimal so it can be shown as a %

casim

casim ✭

10/28/18 edited 12/09/19 in Smartsheet Basics

Is there a way to convert a fraction into a % without having to do it longhand (as in having two columns with fraction values to then present the sum with % formatting).

Thanks in advance.

Tags:

Project Management

0 ·

Comments

Paul Newcome ✭✭✭✭✭✭

10/29/18

Can you provide some screenshots?

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Wrap Text
How do I wrap text within a cell?
Dollar amounts in a form
I am trying to require a form field to only populate a number to display in a dollar format. I can only see the requirement of a number, but not an actual dollar amount. Is this possible in a form?
Copied Smarsheet as new, now Conditional Formatting will not work at all
I copied a Smartsheet and changed some of the column headers. I deleted all the Conditional Formatting because it no longer applied. Then when I set up new Conditional Formatting, very simple - if this cell says YES, make the row green - it will not work at all.

Help shape the future of Smartsheet.
Share your ideas and feature requests.