Welcome!

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

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.

Find more posts tagged with

Project Management

Comments

Paul Newcome

Can you provide some screenshots?

Sign in to join the conversation!

Quick Links

Trending discussions

How to Preserve INDEX Formula Data When Archiving Row?
The Issue My project-specific metadata sheets use INDEX/MATCH formulas that reference the Intake sheet using a Project ID. When the automation archives rows from the Intake sheet, these formulas break because they can no longer locate the source data. Example formula: =INDEX({Project Intake Name}, MATCH([Project ID 1]@row,…
2 of 5 automation workflows in a SMartSheet randomly stopped performing?
Two of my five automation workflows appear to have just randomly stopped performing on April 9, 2026. All others, which would/are performing as normal and would be functioning alongside the other workflows, are functional and appear to be untouched by this 'bug'. Help I've tried all that I can think of.
How do I add horizontal lines to a stack chart for my Dashboard?
I need to add 2 horizontal lines to my stack chart to show when we have over allocated for our resources and where our average is. Does anyone know how to make this happen in a Smartsheet dashboard?