Cell representing % in error despite format settings showing 109% but link cell is 13%

Chuck Millsaps

Chuck Millsaps ✭✭

12/05/23 edited 12/05/23 in Formulas and Functions

smartsheet question on percentage.png

0 ·

Answers

Genevieve P. Employee

12/08/23
Hi @Chuck Millsaps
Is this still happening today? These are the steps I would try before contacting Support:
Double check it's the correct cell being referenced
Delete the reference and re-add it
Sign out of Smartsheet and Sign back in to see if that refreshes the links correctly
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
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

OFFSET calculation
Hello, I am wondering if I could have some help on a calculation matter. As I have tried to find quickly some answers on the forum, it seems that you can not use the OFFSET function from Excel in Smartsheet. Right now I was using it in column H to calculate the stock of the compounds in the inventory. The goal is to add…
Sumifs
Hello, I was wondering if anyone could help me with a sum ifs function. A screenshot of the sheet is included. Basically I want a formula that says if the course name match and the date match, total the costs. So in the example if the course date is 9/16/2024 and the course name is 300, add the three rows of cost. I can…
How to create a formula column that calculates the difference between rows?
I have a sheet1 with columns labeled "Metric Name," "Plan-Actual," and monthly columns where we record the plan and actual numbers consecutively for the same metric name. Metric Name Plan - Actual Last FY - Jun Last FY - Jul Last FY - Jaug Test-01 Plan 90 89 21% Test-01 Actual 90 79 78 Test-02 Plan 90 100 120 Test-02…