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

Remove workspace shared users from 1 sheet
We are working on setting up our Career Reviews in Smartsheets. We have a group of all staff that has access to all sheets in our workspace. I want to remove them access from just the Career Review Sheets. When I do that it says it will remove them from access to the entire workspace, which is not what we want. The only…
Schedule Dates Minus 2 days Except Weekends
I'm trying to figure out a formula. I have a customer that requires a 2 day notice that my crew will be onsite to work. I have an automation set up to remind me to send the store an email 2 days prior. In my "Notify Store" column I have a formula for schedule date -2, but I don't know how to exclude weekends so that the…
PDF Generator Automation Attachments
I've set up an automation to generate a PDF when a row of data is submitted via a form. I have another automation to generate the PDF again each time data in the row changes. I am finding that the subsequent PDF attachment is replacing the first in attachments. Is there a way to have the subsequent PDF added as an…

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