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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
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

text to columns
Hello. I'm looking to split out the following string to provide just the supervisor name and I've yet to figure out the formula.. thoughts on how I do that in a helper column? Thanks Supervisor | Approved by Little, Paul on 12/4/23 @ 11:42 AM |
Was there a change to how the "Modified" filter works
Hello - I am running into a weird filtering issue that I have not had before. We have a new sheet that gets updated each day. Today we imported data into a sheet and I have separate reports based on when the sheet was "modified" However not all the data is showing up.
Dashboard Assistance
Currently, I have a dashboard that reports on our Current and Completed jobs (two unique sheets). There's two fields I'm looking to add together and return the sum onto the dashboard to display our dynamic Currently Billed to Date number. Datapoint 1 - exists in the Sheet Summary for the Current Projects sheet. This…