Percentrage rounding down

Seedster

Seedster ✭

09/17/24 in Formulas and Functions

i'm trying to type 8.5%. Its rounding up to 9%. How do I fix this?

0 ·

Answers

jmyzk_cloudsmart_jp Community Champion

09/17/24 edited 09/17/24

Hi @Seedster

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Check Box for Current Milestone
I am looking for help in writing a formula (or using automations) so that the most recent milestone where the status is "INV PKT SENT & PSR XL UPDT" will have the checkbox. As you can see, I can write a formula to check the box but then when the next milestone reaches that same status I now have multiple checkboxes in the…
Can't get the "Ongoing" piece to work
I'm trying to make a formula, a typical status formula which I do often. But it was asked to include an "Ongoing" status when the % Complete column is at 99%, regardless of other conditions. The problem I'm running into is that no matter how I input it, the "In Progress" piece always overrides it, and I can't quite get the…
COUNTM Formula Help
Is there a way to use the COUNTM formula to count the number of selected dropdown options in a multi-select column (e.g., "Deposit Accounts") only when another column (e.g., "Region") equals a specific value (e.g., "East")? For example, I want to count how many Deposit Accounts have been selected only for rows where the…