Percentage

claire.reynolds03

claire.reynolds03 ✭✭

11/28/23 in Smartsheet Basics

How do you make a number = 100%

I need the 4577 =100% then minus the 1.59%, so the blank column should = 98.41%

0 ·

Answers

delberto ✭✭✭✭

11/28/23 edited 11/28/23

Hi @claire.reynolds03 ,
How about divide it by itself?
=([Column1]@row / [Column1]@row) - [Column4]@row
Would that work?

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

WORKSPACE PANEL - Automatically open when going to a new sheet / report / dashboard
This panel seems to automatically be open when navigating to a new sheet / report / dashboard in the directory. Is this a change? Is there a way to deactivate that being open automatically? thank you, Dave
Do I really have to make the same change on every single one of my sheets separately?
Hi Folks - I'm pretty much a newbie to SS, but I have already created 20+ different sheets for each of my projects, using a template. Now, if I want to make a change to the structure of all the sheets (ie, change the name of a column, add an alert, or anything really!)… is there not a way to automatically make the same…
My automation doesn't send me an email with vertical details; instead I get a very small part of the
I am so frustrated I feel like tearing out my hair! I created this automation: I want to send an email that has all the fields with the information vertical to flow like an email. It worked fine for a week but now I am seeing this: So I only see the first few columns and nothing else. How do I get it back to the way it was…

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